Adding multiple conditions to a filter
You can combine a number of conditions to create complex filters.
As you drag and drop each variable into the Filter pane, the pane builds the conditions that have been defined. Multiple conditions are combined with:
▪And: All of the conditions must be true to pass the filter. This is the default. Combine conditions with the And operator when you want cases to be selected if they satisfy all conditions.
▪Or: Any or all of the conditions are true to pass the filter. Combine conditions with the Or operator when you want cases to be selected if they satisfy either or both of the conditions.
Choose And or Or to add or replace the existing operator.
Moving a condition
To change the order in which a condition appears in the filter after you have added it, click the condition in the Filter pane and then use the up or down arrow buttons on the Filter toolbar.
See also