Filters
A filter is a means of restricting the cases that are included in a table. When you define a filter, you specify characteristics that the data must have to be included. For example:
▪You can specify one or more categories in a categorical variable. For example, you can select respondents who answered Yes to the question Do you hold a biology qualification?
▪You can specify one or more values in a text or numeric variable. For example, you can select respondents who have visited the museum more than 10 times.
▪You can specify conditions from more than one variable. For example, you can select respondents who hold a biology qualification (biology variable) and have visited the museum more than 10 times (visits variable).
▪You can specify whether cases that satisfy the conditions are to be included or excluded. For example, you can include or exclude respondents who hold a biology qualification.
▪You can specify how multiple conditions are to be combined. For example you can specify that cases must satisfy all of the conditions to pass the filter or you can specify that they will pass the filter if they satisfy any or all of the conditions.
After you have defined a filter, the Table Filter text box on the Define tab displays the filter’s description.
There are several types of filters:
▪Table filters. These apply to a particular table.
▪Global filters. These are filters that apply to all tables.
▪Interview filters. These apply to all tables and select respondents based on the interview status. This is useful when working with data, because you can, for example, set up an interview filter to exclude test data and interviews that timed out.
When more than one filter applies to a table (for example, a table filter and a global filter), they are combined using the And operator. This means that cases will be selected only if they meet the criteria of all of the filters.
See