Edit a Filter by Using the Edit Filter Dialog Box

To edit a filter by using the Edit Filter dialog box:

On the Filters tab, open the drop-down list for the filter that you want to edit and then select Edit Filter. The Edit Filter dialog box appears.

Note: The Edit Filter dialog box is not available for datetime data. See Edit a Filter by Using Visual Filter Controls for details about using visual filter controls for a datetime data item.

Select the operator for the filter from the Choose operator drop-down list.

Operators for Character Data

Is	Specifies that a matching value must match one of the filter values exactly.
Is not	Specifies that a matching value must not match any of the filter values exactly.
Begins with	Specifies that a matching value must contain the filter value at the start of the value.
Ends with	Specifies that a matching value must contain the filter value at the end of the value.
Contains	Specifies that a matching value must contain the filter value.
Does not contain	Specifies that a matching value must not contain the filter value.
Is missing	Specifies that a missing value matches the filter.
Is not missing	Specifies that any nonmissing value matches the filter.

Operators for Numeric Data

Is	Specifies that a matching value must match the filter value exactly.
Is not	Specifies that a matching value must not match the filter value exactly.
Between	Specifies that a matching value must be greater than or equal to the first filter value and less than or equal to the second filter value.
Less than	Specifies that a matching value must be less than the filter value.
Less than or equal	Specifies that a matching value must be less than or equal to the filter value.
Greater than	Specifies that a matching value must be greater than the filter value.
Greater than or equal	Specifies that a matching value must be greater than or equal to the filter value.
Is missing	Specifies that a missing value matches the filter.
Is not missing	Specifies that any nonmissing value matches the filter.

Depending on the operator that you specified, select or specify a filter value:

Is, Is not

For character data, select one or more filter values from a drop-down list. For numeric data, enter the filter value in the text field.

Note: For character data, if the number of distinct values is very large then the enter a value in the text field.

Is missing, Is not missing

No filter value is needed.

Between

Enter the lower value in the first text field and the higher value in the second text field.

For all other operators, enter the filter value in the text field.
Click Apply to create the filter condition.
If you create multiple filter conditions, select whether a matching value must meet all of the conditions (All) or if a matching value can meet only some of the conditions (Any.)
(Optional) To delete a filter condition, click the icon next to the condition that you want to delete.
(Optional) To preview your filter results, click Preview Results.
For discrete data, select whether to display the visual filter controls on the Filters tab for this filter (Show results in a list of check boxes) or to show a text description of the filter syntax (Apply results as a dynamic rule.)

Note: If your data contains a large number of discrete values, then visual filtering is not available.
When you are finished editing your filter, click OK to apply the filter.