Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Restoring current selection state

Hi,

My QlikView file has multiple sheets, say Sheet A and Sheet B. The navigation between the sheets is done using text box. Everytime I move from Sheet A to Sheet B, I am currently clearing all the selections made(by defining actions for the text box) . Is it possible for me to store the selections so that if I come back to Sheet A, the previous set of selections (which I am currently clearing) automatically gets applied?

1 Solution

Accepted Solutions
thomas_skariah
Creator III
Creator III

Hi Balaji,

Find the attached.You can use Alternate States concept.

Regards,

Tom

View solution in original post

4 Replies
thomas_skariah
Creator III
Creator III

Hi Balajin,

You can get idea from attached application.You can use sheet trigger 'back'.

Regards,

Tom

Not applicable
Author

Hi Tom,

Thanks for such a quick response.

The solution will not work if I apply any filter in Sheet1- The original selections in the "Main"  sheet will not be retained on making any selections in Sheet1.

Not applicable
Author

Hi Balaji,

you can use bookmark.. While moving from sheet 1 to sheet 2 create a bookmark...

While coming back from Sheet 2 to Sheet 1 apply that bookmark..

That will help you..

Thanks,

Karthik

thomas_skariah
Creator III
Creator III

Hi Balaji,

Find the attached.You can use Alternate States concept.

Regards,

Tom