Next
You can create filters to restrict the cases that are included in a table. For example, suppose you want to create a table that shows information about female respondents only. One way to do this is by filtering the table on the Female category of the gender variable.
You can create simple or very complex filters. For example:
• You can define a condition that includes or excludes one or more categories in a variable. For example, you can select respondents who answered Yes to the question "Do you hold a biology qualification?"
• You can combine conditions using 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 how multiple conditions are to be combined. For example, you can specify that both of the filter conditions must be true for a respondent to be included in the table or you can specify that either one or other of the conditions must be true.
For a comparison between filtering and other methods of removing information from your tables, see Removing categories from a variable.
You can use the following types of filter:
• Table Filters These apply to a particular table. You can also save filters that you have created for a particular table so that you can apply them to other tables.
• Global Filters These are filters that apply to all tables in the table document.
• Interview filters These apply to all tables and select respondents based on the interview status. This is useful when working with IBM® SPSS® Data Collection Interviewer Server 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.