Filter data

[Manni_SM]

Hi 

@rubenmarin @Vegar @marcus_sommer  @rwunderlich 

i have a  filter pane with list of fields  around 30 field with 10yrs of data.

filterpane 1:  list of fields

filterpane 2:   whatever field is selected in field 1 it will show respective field data.

now customer is asking application is getting all the data its impacting dashboard performance. now  is there any alternate method to implement this feature in Qliksense?

[Vegar]

Qlik Sense have a build in feature for this, it is called "Cyclic dimension", please check out  this help page on the topic:  cyclic-dimension.htm 

[Manni_SM]

hi @Vegar  Thanks for your suggestion but cyclic dimension is only possible in charts not in stright table

my requirement is like below

two filers  one straight table.  

[Manni_SM]

Hi @rubenmarin  any suggestions? 

[rubenmarin]

Hi, how is created the 2nd filter list? By default I would use "=[$(=FieldList)]"

[Manni_SM]

Hi @rubenmarin  yes used this

 ='['&$Field &']'

[rubenmarin]

That's different than what I posted. I would have a field that lists all selectable fields, that would be the first selector, and the 2nd would be created as I posted before: [$(=FilterField)]

Or, if you use $Field in field selector, the 2nd would be: [$(=$Field)]

[Manni_SM]

below are the expressions used for  listbox 1 and 2

Sheet Name ObjectID Object Name Location Expression
Main LB01 Field List =IF($Field = 'ACCOUNT_NUMBER' or $Field = 'PRODUCT_CODE' or $Field = 'USD_AMOUNT', Null(), $Field)
Main LB02 - Caption =[$Field]
Main LB02 - =$(vFieldVariable)
Main LB02 - ListBox Title =[$Field]

[rubenmarin]

And have you tried to use [$Field] instead of $(vFieldVariable)?

[Manni_SM]

yes if i use   [$Field]  am getting same result of Filterpane one only..  

present filters are working fine  with my preivous expressions  but

now  customer is asking application is getting all the fields data  almost 10 years data its impacting dashboard performance. now  is there any alternate method to implement this feature in Qliksense?