Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Balaji,
Find the attached.You can use Alternate States concept.
Regards,
Tom
Hi Balajin,
You can get idea from attached application.You can use sheet trigger 'back'.
Regards,
Tom
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.
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
Hi Balaji,
Find the attached.You can use Alternate States concept.
Regards,
Tom