After you add a column to the data filter, a red triangle menu appears. Some of the red triangle options for a variable can vary, depending on the type of variable.
The red triangle menu next to any type of variable contains the following generic options:
Delete
Removes the variable from the Data Filter control panel.
Clear Selection
Clears any selection in effect for that variable only.
Invert Selection
Deselects any selected values, and selects all values previously not selected, for that variable only.
Order by Count
Sorts the values in decreasing order by count.
Find
Opens a search box above the variable to enable you to search for values. The menu item changes to Clear Find after you select it.
For continuous variables, values appear in a range with a slider that you can adjust in one of the following ways:
• Click and drag the slider bar. You can drag from either end of the slider bar. The selected values appear above the slider bar.
• Click anywhere in the empty (not selected) part of the slider to set the filter range at that point.
• Click the number to enter the value that you want.
By default, the range of values includes an equal sign, which includes the endpoints. You can remove the equal sign by holding down the Shift key and clicking on the ≤ or the ≥.
The Select Missing option highlights any missing values in the data table.
For nominal and ordinal variables, values appear in blocks, in a list, or in a menu. If the variable contains only a small number of categories, the values appear in blocks. If the variable contains a large number of categories, the values appear in a list or in a menu. However, you can change these default settings.
The following options are available for nominal or ordinal variables only:
Display Options
Changes the appearance of the display. Options can include the following:
Blocks Display
Shows each level as a block.
List Display
Shows each level as a member of a list, followed by its frequency.
Single Category Display
Shows each level, followed by its frequency, in a menu.
Check Box Display
Adds a check box next to each value. To make this the default setting, select the Check Box Display option in File > Preferences > Data Filter.
Radio Box Display
Adds a radio button next to each value.
Order by Count
Orders the values in decreasing sort order by count.
Find
Provides a text box where you can enter a search string for the selected column. Press the Enter key to perform the search. See Search Filter Options.
The following options are available for variables with the Multiple Response modeling type or column property:
Match None
Selects only rows containing values that do not match any of the selections
Match Any
Selects all rows that contain values that match any of the selected values. By default, this option is selected.
Match All
Selects only rows with values that include all of the selected values.
Match Exactly
Selects only those rows with values that exactly match the checked values.
Match Only
Selects only those rows with contents exactly matching the checked values.
Match At Least
Selects at least n of the selected values.
Match At Most
Selects a maximum of n of the selected values.
Match Between
Selects between n and m of the selected values.
Find
Provides a text box where you can enter a search string for the selected column. Press the Enter key to perform the search. See Search Filter Options.
Note: For more information about the Multiple Response property, see the Multiple Response in the The Column Info Window section.