Jump to content
We've recently updated our Privacy Statement, available here. ×

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


K Rojas

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...