MATLAB: App design UI figure How to Add Excel like Sort & filter selection

app designer sort filter

I want to add filter to my app design as shown in attachment

I have added my source *.mlapp file. For below code, I want to add excel like Sort & filter for all Columns Variables and Row Name data

                TableCellData1                  = timetable2table(joinedtimetable);
                app.UITable.Data                = TableCellData1;
                t_table                         = app.UITable.Data(:,app.UITable.Data.Properties.VariableNames);
                app.UITable.ColumnName          = t_table.Properties.VariableNames;
                app.UITable.RowName             = 'numbered';
                app.UITable.ColumnSortable      = true;
                app.UITable.BackgroundColor     = [1 1 .9; .9 .95 1;1 .5 .5];
                get(app.UITable);
                
                % ui figure for viewing full logs
                f_table = app.UITable.Data(:,app.UITable.Data.Properties.VariableNames);
                fig = uifigure;
                uit = uitable(fig,'Data',f_table,...
                    'ColumnName',f_table.Properties.VariableNames,...
                    'RowName',f_table.Properties.RowNames,...
                    'ColumnWidth',{100});
                uit.RowName = 'numbered';
                uit.ColumnSortable = true;
                uit.BackgroundColor = [1 1 .9; .9 .95 1;1 .5 .5];
                uit.Data = f_table;
                styleIndices = ismissing(f_table);
                [row,col] = find(styleIndices);
                s = uistyle('BackgroundColor','black');
                addStyle(uit,s,'cell',[row,col]);
                uit.DisplayDataChangedFcn = @updatePlot;
                set(uit, 'CellSelectionCallBack',[])
                set(uit, 'CellSelectionCallBack',@selectionChangeCallBack);

Add Sort & Filter

                    'ColumnName',f_table.Properties.VariableNames,...
                    'RowName',f_table.Properties.RowNames,...

Best Answer

My comment moved here to close out the question.

----------------------------------------------------------------

There's currently no built-in methods of sorting and filtering UITables. You'll have to create these features manually.

sortrows may come in handy for simple alphanumeric sorting of the entire table based on a selected column.

For filtering, you can use logical indexing to select which rows should be displayed on the table. It won't be a very difficult task but it will take a bit of an investment of time. I'm sure you can find related questions within this forom on both filtering and sorting of UItables to get you started.

Related Solutions

MATLAB: App designer Table with input numbers of rows and columns

You can create properties and set the values using following code

properties (Access = private) 
        Property % Description 
        colonna=3; %columns 
        slice=2;  %rows 
    end

You can use following code to create table with the given number of rows and columns and with check boxes in each row.

methods (Access = private)  
        % Code that executes after component creation 
        function startupFcn(app) 
             
            fig = uifigure; 
            tdata = table('Size',[app.slice, app.colonna],'VariableTypes',["logical","string","string"]);  % use “logical” to get checkbox in first column 
            uit = uitable(fig,'Data',tdata,'ColumnEditable',[true false false]); %  columns can be editable if ColumnEditable is true  
            uit.Position(3) = 130; 
            uit.RowName = 'numbered'; 
        end 
    end

Hope this helps!

MATLAB: How to stackedplot with text data

** UPDATE**

Almost a year later I learned of a way to add text to stackedplot axes. See this answer:

https://www.mathworks.com/matlabcentral/answers/483059-insert-text-in-stacked-plot-points#answer_550413

** Original answer showing alternative solution **

I'm assuming you're positioning text according to this screen shot you shared in an earlier question. Since text cannot currently be added to stackedplot axes (as for r2019b, let's hope that changes), here are two workarounds

Use an alternative function

(added on 11/19/20)

stackedaxes() on the file exchange is a limited alternative to Matlab's stackedplot and returns the axis handles so that you can add to or modify the plot after it is created.

Create your own custom stacked axes

Create axes, link their x-axis limits, and then add text to each axes.

% Create input table for demo because OP did not provide table
T = table((duration(0,0,17):seconds(1):duration(0,0,20))',...
    {'abc','','bcd','cde'}',...
    {'test1','','test3','test4'}',...
    {'autoserv1','','autoserv3','autoserv4'}',...
    'VariableNames',{'WeirdDuration','lot_test','Sublog','Message_test'})
T = 4x4 table
    WeirdDuration     lot_test       Sublog      Message_test 
    _____________    __________    __________    _____________

      00:00:17       {'abc'   }    {'test1' }    {'autoserv1'}
      00:00:18       {0×0 char}    {0×0 char}    {0×0 char   }
      00:00:19       {'bcd'   }    {'test3' }    {'autoserv3'}
      00:00:20       {'cde'   }    {'test4' }    {'autoserv4'}

% The only input would be "T", the table created above.  It is assumed that 
% The x values are stored in the first column named 'WeirdDuration' and that
% a subplot should be created for each subsequent column in T.  
% Create figure with linked subplots stacked vertically
fig = figure(); 
nSub = size(T,2)-1; %number of subplots assuming 1 subplot for each col of T except the first
% in order to maximize spaces, create subplots manually. 
margins = [.11 .11 .08 .12 .01];  %margins: left, right, bottom, top, vertical space between plots
height = (1-sum(margins(3:4)) - (nSub-1)*margins(5))/nSub; %height of each subplot
width = 1-sum(margins(1:2)); % width of each subplot
subPos = margins(3):height+margins(5):1; %vertical position of each subplot from bottom to top (may have extra values at end)
subHand = arrayfun(@(i)axes(fig,'Position',[margins(1),subPos(i),width,height]),1:nSub); 
% add grids
set(subHand,'XGrid','on') % you could add 'YGrid','on'  if you wish
% How loop through each subplot (i) and add text from column i+1
x = T.WeirdDuration; % the x coordinates of your text
y = 1:size(T,1);     % the y coordinates of your text
for i = 1:nSub
    th = text(subHand(i), x, y, T{:,i+1},'VerticalAlignment','Bottom'); 
    ylim(subHand(i),[min(y),max(y)+1])
    xlim(subHand(i),[min(x),max(x)+range(x)*.1]) %adds 10% of axis range 
end
% Link x axes so the x limits are always the same
linkaxes(subHand,'x'); 
% Remove x tick for all but bottom axes
set(subHand(2:end),'XTickLabel', [])
●

Best Answer

Related Solutions

MATLAB: App designer Table with input numbers of rows and columns

MATLAB: How to stackedplot with text data

Related Question