topic Re: Filter data in App Development

Filter data

Manni_SM — Fri, 05 Sep 2025 03:52:55 GMT

@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?

Re: Filter data

Vegar — Fri, 05 Sep 2025 05:00:33 GMT

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

Re: Filter data

Manni_SM — Fri, 05 Sep 2025 09:28:21 GMT

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.

Re: Filter data

Manni_SM — Sun, 07 Sep 2025 07:49:32 GMT

Hi @rubenmarin any suggestions?

Re: Filter data

rubenmarin — Mon, 08 Sep 2025 06:56:09 GMT

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

Re: Filter data

Manni_SM — Mon, 08 Sep 2025 07:27:06 GMT

Hi @rubenmarin yes used this

='['&$Field &']'

Re: Filter data

rubenmarin — Mon, 08 Sep 2025 07:33:29 GMT

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)]

Re: Filter data

Manni_SM — Mon, 08 Sep 2025 07:35:08 GMT

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]

Re: Filter data

rubenmarin — Mon, 08 Sep 2025 07:37:59 GMT

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

Re: Filter data

Manni_SM — Mon, 08 Sep 2025 07:41:45 GMT

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?

Re: Filter data

rubenmarin — Mon, 08 Sep 2025 07:49:08 GMT

Have you really confirmed than the selectors is what is caused the perfomance degradation?

I would try to use 'standard' field selectors, just adding a selector by each field, try only with a few, and then check performance, If it still has degraded performance, then it has nothing to do with this selectors, maybe it's just because the added years of data, and the issue then could be in the data model or lack of resources to manage all data.

Also note that, if this is for Sense, you have the selector tool included by default in qlik sense, where you can find all the possible fields to make selections

Re: Filter data

Manni_SM — Mon, 08 Sep 2025 07:52:07 GMT

Okay thanks i will do those checks and update

Re: Filter data

Manni_SM — Mon, 08 Sep 2025 08:11:43 GMT

Hi @rubenmarin if customer use selection tool

1 .do we need to remove above two fiter panes ?

2. if we remove app will be optimized ?

Re: Filter data

rubenmarin — Mon, 08 Sep 2025 09:43:23 GMT

Hi, first you have to identifiy what is causing the performance degradation.

You can try option 2 in a copy of the app.

Based on what is causing degradation you can will know if you need to de the point 1 or it would be useless.