topic Re: Keep selections for several fields in Triggers in App Development

Keep selections for several fields in Triggers

matthieu-hoffmann — Sat, 16 Nov 2024 01:47:31 GMT

Hi everyone,

I'm using the sheet triggers added in April 2020 in my Qlik Sense application (on April 2020 SR3).

On every page, I activated "clear selections in other fields" and used my Year field. But what if I also would like to keep the Month field, the Date field ? And eventually a 4th one ? I tried with 2 triggers but it doesn't work. Is there another way, eventually with other triggers in a specific order ?

I need every sheet to retrieve their initial aspect except for these selections.

Thanks for your help.

Re: Keep selections for several fields in Triggers

ArnadoSandoval — Wed, 29 Jul 2020 05:08:17 GMT

Hi @matthieu-hoffmann

It seems we need to understand this functionality behaviour to better implement it; I did some test with a sales application-dashboard that allows me to filter on the fields year; month; day and city; these are my results:

This is my UI, with 4 selectors:

I implemented a trigger with its action: "clear selections in other fields" as shown; I assigned the City field instead of the Year one:

The trigger cleared the selections for all my selectors but the City; It will be challenging implementing multiple "clear selections in other fields" actions to achieve what you want to do.

So, I changed the action to "Clear selections in field", and implemented a second trigger with similar action of the Sales_Day field, as shown.

The outcome of my second test was promising, it allows us to keep selections for several fields by clearing the selections we do not want; I think this is what you want to do!

Please let us know if this approach resolve your issue!

Hope this helps,

Re: Keep selections for several fields in Triggers

matthieu-hoffmann — Wed, 29 Jul 2020 05:27:58 GMT

Hi,

Thank you for your tests.

Nevertheless, I can’t procede thus because except my four common fields in every pages, I have multiple other ones, not the same everywhere. And I can’t add 30+ exceptions in my triggers...

Re: Keep selections for several fields in Triggers

ArnadoSandoval — Wed, 29 Jul 2020 05:52:49 GMT

@matthieu-hoffmann

Have you consider using Alternate States instead?

hth

Re: Keep selections for several fields in Triggers

matthieu-hoffmann — Wed, 29 Jul 2020 07:42:07 GMT

Yes, but I have so many objects in my application...

I also thought about using all my fields in a variable and use this in a set analysis to exclude them like Count(distinct {<Year=,Month=,>} %IdCustomer)

The easier way appeared Qlik let us the possibility to choose several fields in the trigger used.