Spotfire Apply Multi-select values from a property control to a filter using a script
I'm trying to figure out how to allow the user to select multiple values from a Property Control, and have those values passed to a filter.
The filtering needs to be conditional for two different related tables, so I have to use a list box tied to a property control, and handle the filtering with a script.
I have a current working version that allows for only one selection, but I need to be able to select multiple. I have included this DXP as an example.
The script I'm using to filter by 1 selection at a time is:
from Spotfire.Dxp.Application import Filters from Spotfire.Dxp.Application.Filters import CheckBoxFilter
Filter1.IncludeEmpty = False for value in Filter1.Values:
Filter2.IncludeEmpty = False for value in Filter2.Values:
if program == "All": Filter1.Check(program) Filter2.IncludeEmpty = False for value in Filter2.Values: Filter2.Check(value) if program <> "All": Filter1.Check(program) Filter2.Check(program)