SpotFire: How to create a filter to select only the columns (and NOT the specific values in columns)

[Xav Dou]

Hi,

I imported several columns from a database.

I create different visualization (bar chart, and so on)

I want to create a filter in a Text area to selectthe columns i want to show in all the visualization.

My issue is that the filters (list box, drop down list, and so on) allow only to selectspecific values in one column. I did not find a filter to show/hide one or more columns.

For example: I want to filter Column1 (and not only value A in Column1)

 

 

 

Column1

Column2

 

 

A

1

 

 

B

2

 

 

C

3

 

 

 

 

 

 

 

Thanks in advance you for your support!

[Khushboo Rabadia]

You can create dynamic property control > Multiselect list box > Column selection and then trigger iron python script to add/remove columns dynamically from table plot. In other plots, you can just add this property in custom expression of X-axis

 

Iron python script references:

https://spotfired.blogspot.com/2014/04/add-columns-dynamically-to-data-table.html

https://community.spotfire.com/wiki/example-script-modify-which-columns-are-shown-table-plot

https://community.spotfire.com/wiki/ironpython-scripting-tibco-spotfire

https://datashoptalk.com/dynamic-control-properties/