topic Re: Restoring current selection state in QlikView

Restoring current selection state

Fri, 31 May 2013 03:14:29 GMT

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?

Re: Restoring current selection state

thomas_skariah — Fri, 31 May 2013 03:52:48 GMT

Hi Balajin,

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

Regards,

Tom

Re: Restoring current selection state

Fri, 31 May 2013 04:12:42 GMT

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.

Re: Restoring current selection state

Fri, 31 May 2013 04:21:57 GMT

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

Re: Restoring current selection state

thomas_skariah — Fri, 31 May 2013 04:29:17 GMT

Hi Balaji,

Find the attached.You can use Alternate States concept.

Regards,

Tom