topic Re: How to handle the filters when multiple sheets in QlikView

How to handle the filters when multiple sheets

viswamtulasi — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I've multiple sheets in my Dashboard -

Based on my current sheet selection criteria and filtering the objects values on all other sheet object results as-well....

The Alternate State can help, but I've many objects on each sheet and it will be a tedious job to create / setup on all object places.....

Instead of alternate state any other way to handle such scenario and is there any way -

At sheet level selections and the current selections should not affect other sheet object filters….

Thanks in advance..

Re: How to handle the filters when multiple sheets

MarcoWedel — Tue, 19 Jun 2018 21:06:32 GMT

When applying different alternate states to your sheets itself, all objects being in default state <inherited> get their states from the sheet they are placed on, so maybe not quite that tedious an endeavour as you feared.

Re: How to handle the filters when multiple sheets

viswamtulasi — Tue, 26 Jun 2018 07:42:00 GMT

I've setup the alternate state and assigned at sheet level properties - however it is not working at object level so I've added the same state at object level so that it is working....

Only the drawback is even I've given at sheet level and again I've been assigning the same state object level then only the results are showing as correct.

Re: How to handle the filters when multiple sheets

MarcoWedel — Wed, 27 Jun 2018 19:56:27 GMT

Seems odd.

Can you post a sample application that shows this behaviour?

Re: How to handle the filters when multiple sheets

BalaBhaskar_Qlik — Thu, 28 Jun 2018 14:40:42 GMT

May be like this:

Set variables like this & use these variables in set analysis.

=Concat({AltState1} DISTINCT Product,'-')

=Concat({AltState2} DISTINCT Product,'-')