How to limit data of visualizations based on the selected values of a multiselect list box property control in TIBCO Spotfire

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:

Products Versions
Spotfire Analyst All

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