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.

  1. create “property control – drop down list” mydropdownlist
  2. select “unique column value ” populate drop down list (values).
  3. go “insert -> calculated column”
  4. use simple conditional statement if([value1] = ‘${mydropdownlist}’, [value 2], null)
  5. use newly created column in text area filter. updated based on previous section.

thanks.


Comments

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

java - How to filter a backspace keyboard input -

java - Show Soft Keyboard when EditText Appears -