How to limit data of visualizations based on the selected values of a multiselect list box property control in TIBCO Spotfire
book
Article ID: KB0072036
calendar_today
Updated On:
Description
Consider an example where you have the following dataset and you want to limit the data in the visualization based on the user names which are selected in multi-select List box property control which is named as "test".
Dataset:
Name Birthdate
Sherlock 24/08/1980
Holmes 24/12/1989
Issue/Introduction
This article describes how to limit data of visualizations based on the selected values of a multiselect list box property control in TIBCO Spotfire Analyst, using "Limit data using expression" and the Find function.
Resolution
Right click the visualization in which you want limit the data, choose "Properties">"Data", and under the "Limit data using expression:" section use the following expression.
Find([name],'${test}')>0
Additional Information
- Find function (Text functions), TIBCO Spotfire Analyst 12.0 User's Guide
Feedback
thumb_up
Yes
thumb_down
No