Create and Bind a Parameter to Exclude Filter Values
Set a filter to exclude data values and then use the Bind to Parameter option to create and bind an excludes parameter to the filter. After you create the parameter, you can bind it to other filters in the workbook to pass excluded data values between filters.
This tutorial provides a use case explaining how to use a parameter to
exclude filter values that you pass to another canvas.
This tutorial provides a use case explaining how to apply an exclusion list
filter to all canvases in a workbook.
You can create and bind a parameter to exclude data values in:
- Workbook filters
- List, list box, range, and inline list dashboard filter types
The excludes parameter you create uses the Integer data type
and contains Boolean values, and is added to the workbook's
Parameters tab. The excludes parameter shares
the filtered column's name, for example, if you bind an excludes parameter
to a City column filter, the binding creates a parameter named Excludes
City.
You can also select an existing excludes parameter to bind to a
filter. An existing excludes parameter must use the Integer data type and
contain Boolean values.
Before you create and bind an excludes parameter, you must set the filter's
values and bind a parameter to the filter. This is to ensure that the
exclusion list is passed to the parameter.
- On the Home page, select the workbook with the filter you want to create and bind an excludes parameter to, click Actions, and then select Open.
- Locate and click the filter that you want to bind the excludes parameter to.
- For a workbook or list or range dashboard filter:
- In Selections, confirm that the filter values are set to the values you want to exclude and that the Bind to Parameter icon (x) is green, indicating that a parameter is bound to the filter.
- Click Exclude, click Bind to Parameter (x), and then click Create Parameter to create and bind the excludes parameter to the filter.
- For a list box or inline list dashboard filter:
- Click Properties and click Filter Controls.
- Go to the Parameter Binding (Selection) field and confirm that a parameter name is displayed, indicated that a parameter is bound to the filter.
- Go to the Exclude Selection field and set it to On.
- Locate the Parameter Binding (Excludes Mode) field and click None. Click Create Parameter to create and bind the excludes parameter to the filter.
- Click Save.