Edit a Filter

Edit the criteria of a filter, by adding, editing or removing conditions and condition sets.
If the Filters view is not displayed, select Windows > Show View > Filters.

Ensure you have created a filter first (Create a Filter) before following these instructions.

  1. In the Filters view, expand the required filter to show the existing condition sets and conditions.
  2. To add a new condition:
    1. Select the parent condition set for the new condition, and then click New Condition(New Condition).

      The New Condition dialog box is displayed.

    2. Complete the condition details as explained in Create a Filter.
  3. To update existing condition criteria:
    1. Right-click the required condition and select Properties.

      The Condition Properties dialog box is displayed.

    2. Complete the condition details as explained in Create a Filter.
  4. To add a new condition set:
    1. Select the parent condition set for the new set, and then click New Condition Set(New Condition Set).

      An AND condition set is created by default.

    2. If required, click the new set and select OR to change the type.
  5. To delete a condition or condition set:
    1. Select the condition or condition set, and then press Delete.
    2. Click Yes to confirm deletion.

      The item is removed from the filter.

    Edits to a filter are automatically saved, but if you are editing the active filter, the asterisk next to the filter icon (Updated results) indicates you should update the filtered view.
  6. click Refresh Filtered Results(Refresh Filtered Results) to reapply the filter to the data file.