1. User’s Guide for Oracle Analytics Desktop
  2. Filter Data
  3. Exclude Selected Filter Values

Exclude Selected Filter Values

You can configure a filter to exclude rather than include the selected data values.

You can exclude data values for filters created on certain column types using certain filter types. For example, you can exclude data values for an attribute column filter but the filter type must be List, List Box, or Checkbox / Radio Button. You can't exclude data values for filters on measure columns.
You can use also parameters to pass excluded values between filters, see Create and Bind a Parameter to Exclude Filter Values.
  1. On the Home page, hover over a workbook, click Actions, then select Open.
  2. For a workbook or canvas filter, on the filter bar, click the filter to open the Filter dialog, and then select Exclude.
  3. For a dashboard filter:
    1. If the filter type is List, in the dashboard filters visualization, click the filter to open the Filter dialog, and then select Exclude.
    2. If the filter type is List Box or Checkbox / Radio Button, click Properties to open the Properties pane, and then click Filter Controls.
    3. Locate and expand the filter you want to exclude values for, click the Exclude Selection field, and then select On.
  4. For a visualization filter, in the visualization, click the filter to open the Filter dialog, and then select Exclude.
  5. Click Save.