Keep selections for several fields in Triggers

[matthieu-hoffmann]

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.

[ArnadoSandoval]

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,

[matthieu-hoffmann]

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...

[ArnadoSandoval]

@matthieu-hoffmann 

Have you consider using Alternate States instead?

hth

[matthieu-hoffmann]

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.