Products | Versions |
---|---|
Spotfire Analyst | All Versions |
There are scenarios when you may want to show which set of values have been filtered out and are therefore excluded from the data table on which visualizations are based. Using an expression like the following in a Calculated Value will only list the values which are current selected in the filter, and not the ones excluded:
Uniqueconcatenate([Region Values]) as [Region Values]This is because those filtered out values are completely excluded and are not part of the data set used for the calculated value, and so this approach cannot be used.
Column Name: ConcList Expression: Concatenate(UniqueConcatenate([RegionNew]),", ")Note: This will add a comma space at the end of the list.
Column Name: Regex Expression: Concatenate("(",[RegionNew],",)")
Left(Trim(RXReplace(First([ConcList]),RXReplace(UniqueConcatenate([Regex]),", ","|","g"),"","g")),-1) then SN([Value],"All values are filtered out")This regex will help you check if the filter value selected is part of the above list or not. If it is part of above list, replace it.