Need independant sheets that saved selections

[Lisa2]

Hello, I have one data source (Excel sheet), three tabs/sheets in QlikView with charts and graphs that use this data source.  I need for each sheet's selections to be independent of the other and for those selections to stay put when I switch back and forth between other pages.  I have done bookmarks and that didn't work.  Similar posts to this were no help either.  What else can I do?

[saar_lorena · Accepted solution]

Hi 😃

You can use the triggers on the sheet properties.

On your sheet, right click, go to triggers sheet.

Then, Add Actions(s)..

Click to add, and it will open actions tipes. You can choose, for instance, Clear All to start cleaning all your filters, and then 'Select in Field' a value for your filters.

Check this video:

https://www.youtube.com/watch?v=9vKN4-FgXZE

Maybe it can helps 😉  

[kuba_michalik]

Create as many alternate states as there are sheets, assign each sheet to its own alternate state and make sure all objects on the sheet have their state set to <inherit>