topic Re: Need independant sheets that saved selections in QlikView

Need independant sheets that saved selections

Lisa2 — Sat, 16 Nov 2024 20:38:19 GMT

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?

Re: Need independant sheets that saved selections

saar_lorena — Tue, 18 Jun 2019 17:23:34 GMT

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 😉

Re: Need independant sheets that saved selections

kuba_michalik — Tue, 18 Jun 2019 18:03:49 GMT

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>