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:
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.
Modeling Type
Shows a submenu of modeling types for the column filter. By default, the column filter type is set to the column’s modeling type. You can change the filter type by selecting a different modeling type in the submenu.
For continuous variables, values appear in a histogram with vertical lines at the minimum and maximum values. You can adjust the selected range by clicking on the vertical lines and dragging. The updated range is highlighted in blue.
The following options are available for continuous variables only:
Select Missing
Selects rows that contain missing values.
Include Minimum Value
Includes or excludes the minimum value in the selected range. When the minimum value is excluded, the solid vertical line in the histogram becomes a dashed vertical line.
Include Maximum Value
Includes or excludes the maximum value in the selected range. When the maximum value is excluded, the solid vertical line in the histogram becomes a dashed vertical line.
Set Number of Bins
Sets the number of bins for the histogram.
Zoom to Selection
Shows only the selected range in the histogram. The menu item changes to Reset Zoom after you select it. Reset Zoom resets the display.
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 Enter to perform the search.
The following options are available for variables with the Multiple Response modeling type or column property:
Display Options
Changes the appearance of the display. Options can include the following:
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.
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 Enter to perform the search.
Note: For more information about the Multiple Response property, see the “Multiple Response”.
The following options are available for variables with the Unstructured Text modeling type:
Case Sensitive
If this box is checked, the filter based on the word or phrase typed in the filter text edit box is case sensitive.
Regular Expression
Assumes the string typed into the filter text edit box is a regular expression instead of a literal string.
Display Options
Changes the appearance of the display. Options can include the following:
List Display
Shows each word or phrase as a member of a list, followed by its frequency.
Single Category Display
Shows each word or phrase, followed by its frequency, in a menu.
Check Box Display
Adds a check box next to each word or phrase. 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 word or phrase.
Add Missing
Adds a filter for entries that do not contain any text.
Clear Filter Texts List
Removes any words or phrases that had been added to the filter text list.
Show Filter Text Edit Box
Shows or hides the filter text edit box.
Order by Count
Orders the words or phrases in decreasing sort order by count.
Match None
Selects only rows containing text that does not match any of the selected words or phrases.
Match Any
Selects all rows that contain text that matches any of the selected words or phrases. By default, this option is selected.
Match All
Selects only rows with text that includes all of the selected words or phrases.