How to filter out the empty values using the List box filter with check boxes.
Article ID: KB0081317
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.5 and higher |
Description
In the List box filter with check boxes (Filtering Scheme Properties >> Select 'Show check boxes'), the empty check box does not gets selected (checked) when we select 'All values' option. In spite of being unchecked, the corresponding rows having empty values in the concerned column are displayed. So, checking or unchecking of the empty check box has no effect on the filtering.
This option (Show check boxes) seems to have been introduced in 7.5. Prior to that, this option was not there. We use this option instead of a simple check box filter when we have more than 100 unique values in the column. Because, in that case, check box filter is grayed out.
This option (Show check boxes) seems to have been introduced in 7.5. Prior to that, this option was not there. We use this option instead of a simple check box filter when we have more than 100 unique values in the column. Because, in that case, check box filter is grayed out.
Issue/Introduction
How to filter out the empty values using the List box filter with check boxes.
Resolution
Here is a workaround to filter out the empty values:
1. In the List box filter, select (Empty) option only.
2. In the table plot, mark all the rows (These are the rows having empty values in the concerned column)
3. Right-click and select "marked rows" -> "filter out".
4. Select (All) in the filter again.
This will filter out all the rows having empty values in the concerned column for which we are using this List box filter.
Feedback
Yes
No
Powered by
