Bulk updating table filters
You can bulk update the filters for multiple tables. When you select multiple tables, that have the same filters, the selected tables will display as a single table. Expression and level changes for the displayed filter will apply to all selected tables.
When the selected, multiple tables have different filters, the Multiple filters place holder will display for the filter to indicate that the selected table filters have differing expressions or levels. The place holder can only be replaced or deleted.
To replace the Multiple filters place holder
Replace the place holder by selecting different variables and clicking Replace.
All filters for the selected tables are replaced with the selected variables, and all filters will be set to the top level.
To delete the Multiple filters place holder
Select the place holder, and then press Delete.
The filters are cleared for all selected tables.
Advanced multiple table filter conditions
The Filter pane displays multiple table filters in a graphical format. The full filter expression displays in the Filter Syntax pane at the bottom of the screen. The place holder is identified in the expression as %Multiple filters%. Using the tables displayed in the image above as an example, selecting three tables that have different filters will display the following in the Filter Syntax pane:
%Multiple filters%
The %Multiple filters% place holder can only be removed or replaced in the Filter Syntax pane.
1 Click Apply to validate the current syntax.
If the syntax is valid, the Filter pane displays the filter conditions. If the syntax is not valid, an error message appears.
2 Click Cancel to return the previously applied syntax.
See also