Filters
Filters limit the cases that are summarized in tables by excluding cases that do not match the filter specification. For example, a filter of Gender=Female includes women and excludes men and anyone who did not answer the question.
You can also filter tables based on interview status. This allows you to exclude interviews with certain statuses from the tables. For example, you might want to exclude all interviews apart from those that have a completed status.
Building filters
Build Filter opens a new window in which you select the variables and values that cases must match in order to be included in the tables.
A filter specification consists of three things: a variable name, a logic operator and a value or set of values. The logic operators and the prompt for a response or value vary according to the type of variable you select.
You can define filters based on one or more variables. If the filter is based on more than variable, you can choose whether the individual filters are combined using And or Or logic.
As you build the filter, the Filter Expression panel at the bottom of the window displays the filter text that will appear on the table.
To build a filter
1 Select Actions > Build Filter.
This opens the Build Filter window.
2 In the Variable List select a variable that you want to use as a filter.
Survey Results draws the Build Filter section of the window to suit the type of variable you have chosen.
3 In the Logic box select a filter operator.
4 In the Respondent(s) box select or enter the response or value that is to be used as the filter.
As you select responses, the Filter Expression is updated to show the filter condition to be applied.
5 Click Apply to close the filter and apply it to the current table. Alternatively, click And>> or Or>> to define an additional filter.
Filtering on a single response variable
Logic operators for single response variables are as follows:
▪Any of these. Only cases that contain one of the selected answers.
▪None of these. Only cases that contain none of the selected answers.
Choose an operator and then select one or more filter responses from the list of available responses.
Filtering on a multiple response variable
Logic operators for multiple response variables are as follows:
▪All of these. Only cases that have all of the selected answers.
▪Any of these. Cases that contain one or more of the selected answers.
▪None of these. Only cases that contain none of the selected answers.
▪Exactly these. Only cases that have the selected answers and no others.
Choose an operator and select one or more filter responses from the list of available responses.
Filtering on a numeric variable
Logic operators for numeric variables are:
▪Less than
▪Greater than
▪Equal to
▪Not equal to
▪Less than or equal to
▪Greater than or equal to
Choose an operator and enter the value with which to compare the data.
Filtering on a text variable
Logic operators for text variables are:
▪Contains
▪Does not contain
▪Is exactly
▪Begins with
▪Ends with
▪Is blank/empty
If you choose any operator other than Is blank/empty, you must enter a text to be used as a filter.
All operators except Ends with are case insensitive. With Ends with, you must type the text in the same case that it appears in the case data, otherwise the filter will fail.
Filtering on a grid variable
The grid is presented already ‘sliced’ into its various subquestions. Choose the variable that represents the subquestion on which you want to base your filter. If the variable is a single or multiple choice grid, the slice will be a single or multiple choice variable and you can choose the responses on which to filter. If the grid contains numerics, the logic operators for a numeric are displayed. If the grid contains single or multiple choice responses, the logic operators for those variable types are displayed.
Clearing filters
Clear Filter removes the filter from the table and refreshes the table so that it is no longer filtered.
To clear the current filter, select Clear > Clear Filter.
See also