Spotfire Filters

Filtering

The Document handles the collection of filtering schemes. Each filtering scheme contains as many filter collections as there are tables. Consequently the scope of a filtering scheme is the whole data set.

A filter collection contains filters for a given table. Each filter defines a row selection, and the filter collection combines the selected rows to a resulting set of rows.

There are several filter types: range filter , item filter, text filter and so forth. All non-hierarchy column filters can can easily be converted to another filter type, while hierarchy filters are always tied to a hierarchy column.

Related API Documentation

• FilteringScheme
• FilterCollection
• Filter
• IndexSet
• FilterTypeIdentifiers
• HierarchyColumn

Code Example

• Adding a Filtering Scheme
  The filtering scheme collection is synchronized with the data manager's filtering selection collection. Filtering schemes are added by adding a filtering selection.
• Altering the Lower Limit of a Range Filter
  Code example showing how to change the lower limit of a range filter programmatically.

Layout

There is a table group for each loaded table. The table group header is hidden when there is only one table.

The Filter panel illustrated to the left holds two data tables and a filter group.