When you load data into Spotfire, each column in the data table is represented by a filter. The filters are available in the Data in analysis flyout as well as the Filters panel.
In the Filters panel, all filters in a data table can be viewed at the same time, and you can use the filters directly to limit the data to visualize. The filters are of different types depending on what type of data the column contains.
The filters in the Filters panel can be organized just as you please, and also hidden. In case the analysis holds different filtering schemes, the Filters panel is where you select which filtering scheme to apply on the page.
The Filters panel can be displayed as a popover or a docked
panel. See Panels and
Popovers for more information. Click the Filters button 
on the menu bar, or select View > Filters
to show, or hide, the panel. It will open in the mode it was opened
the last time you had it open. The visibility of the panel is controlled
per page, and the Filters visibility of new pages is inherited from the
active page. The image below shows Filters as a docked panel with the
different filter types.
Number |
Filter Type |
1 |
Range Filter |
2 |
Item Filter |
3 |
Radio Button Filter |
4 |
Check Box Filter |
5 |
Text Filter |
6 |
List Box Filter |
7 |
Hierarchy Filter |
Note: Binary columns cannot be represented by filters.
When more than one data table is available in the analysis, data table headers are automatically displayed above the filters.
If some data tables are related to each other you can click on the Filtering in related data tables icon to change how filtering should work. See Filtering in Related Data Tables for more information.
Information about Filtered Data
Details about which columns have been filtered, and to which values, are displayed at the bottom of the Filters panel. If you want to modify what has been filtered in a filter, you can open the filter from here by simply clicking it.
Above, the expanded view is shown. To collapse the filter
details, click the 
button.
Filters can be reset to their original state (all values selected) in different ways:
You can click the 
buttons above to reset
separate filters.
You can right-click a filter in the upper section of the filters panel and select Reset Filter.
You can click the 
button
above or select Reset All Filters, either
from the pop-up menu in the filters panel, in the data
in analysis flyout, on the toolbar, or from the Edit menu,
to return all filters, visible or hidden, in the active filtering
scheme to their original state.
If you want to reset only visible filters, click the Reset Visible Filters button in the header of the filters panel. Note that this functionality is based on which filters are shown in the Filters panel only, and not related to any filters that you have added to a text area. This means that if a filter is hidden from the Filters panel, it will not be updated using this action, regardless if you can see it in the text area or not.
Note that resetting filters will only affect modifications related to filtering of the data, for example, if you have cleared any check boxes in a check box filter, or narrowed down the range of values in a range filter. Other changes, such as renaming a filter, changing the filter type or scale, will not be affected.