filtering - Nested Filter options in Spotfire -
i learning create reports using spotfire. please me understand feasibility.
is possible change filters based on previous selection(filters has altered based on previous section)
for example:
i have following table, 3 columns.
filter1 filter2 data name name1 test1 age age1 test2 location location1 test3
i planning have filter options based on column filter1 , filter2.
is possible create drop down values "filter1" , "filter2"? possible modify list of filter options, based on first drop down selection.
for example. if "filter1" selected in drop down. list of filter options should "name","age", "location".
if "filter2" selected in drop down. list of filter options should "name1","age1", "location1".
thank you
we can create cascading drop down list through following steps.
- create “property control – drop down list” mydropdownlist
- select “unique column value ” populate drop down list (values).
- go “insert -> calculated column”
- use simple conditional statement if([value1] = ‘${mydropdownlist}’, [value 2], null)
- use newly created column in text area filter. updated based on previous section.
thanks.
Comments
Post a Comment