Save and Restore Previous Selections

[qlikwiz123]

How can I use the bookmarks within sheets of a single QVW document?

For example, I've three tabs on my .QVW application tab a1, b1 and c1. When I am in a1 I make few selections, but when I move on to tab b1 I want all the selection in a1 to get cleared and start with brand new selection in tab b1. However, when I come back to tab a1, I want to clear all the selection made in b1 and restore the previous selection made in tab a1. How can I preserve the selections everytime from tab to tab and reapply them when I come back to that tab?

Solution without Macros is appreciated.

[rubenmarin]

Hi, it's recommend to avoid macros if possible.

I think it can be done with actions, PFA.

[rubenmarin]

When the sheet is activated it applies a bookmark (one bookmark per sheet), when the sheet is left the bookmark is updated.

Bookmark IDs can be shown on Boomarks->More...

[qlikwiz123]

What if my tabs are not sheets but objects in the same sheet? How to use it in place of OnActivateSheet and OnLeaveSheet?

[rubenmarin]

How tabs are selected? Actions can be set also on text objects and buttons.

[qlikwiz123]

I am using two text objects to replicate tabs. Selecting on each text object replicates a tab/sheet change.

[rubenmarin · Accepted solution]

Maybe with a variable that controls the active tab, PFA.

[qlikwiz123]

Thank you so much Ruben. Looks like this would work. Will test and let you know

[qlikwiz123]

The bookmarks work fine locally but fail in Server, especially the Replace Bookmark function. Any pointers? I saw many users talking about this in the community

[rubenmarin]

I don't have now a server to test but maybe the ID of the bookmark changed to (or has to be created in server as) ServerName\BookmarkID