Get values of listbox filter and pass to filter of another table

[K Rojas]

Hello experts,

I have two tables with different data but the same column names. One table represents a member of a larger set. The other represents the total remaining members. Basically, I need to show how this one member compares to the total. There is no way to create a relationship bewteen the tables as this creates an artificial parity.

Is there a way to take the values selected for a filter on table A and use those values to limit the same filter on table B This would be ideal, as this maintains the cascading effect in the filter panels. Thanks for the help.

[Khushboo Rabadia]

You can use Iron Python script to apply filter in other data table:

Get filter value

https://community.spotfire.com/wiki/how-pass-filter-value-visualization-title-using-ironpython-script-tibco-spotfire

Set filter value

https://community.spotfire.com/wiki/how-get-or-set-specific-filter-using-ironpython-script-tibco-spotfire

You can trigger this Iron python script either using action control button or through data function or javascript. Below are some references on it:

https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-45663

https://spotfired.blogspot.com/2015/10/update-doc-property-trigger-ironpython.html