topic Retaining Selections using bookmark or macro in QlikView

Retaining Selections using bookmark or macro

udaya_kumar — Fri, 30 Aug 2013 07:14:39 GMT

Hi,

I have two sheets sheet1 and sheet2.

When i go to sheet2, i clear all selections and retain few selections in sheet2 from sheet1.

I need to retain the previous selections of sheet1 which were cleared, when i move from sheet2 to sheet1.

How we can achieve this?

Re: Retaining Selections using bookmark or macro

Andrea_Ghirardello — Fri, 30 Aug 2013 07:37:51 GMT

You can use sheet triggers.

Use "Replace bookmark" action on "OnLeave Sheet" event to save current selections and "Apply bookmark" action on "OnActivate Sheet" event to apply the saved selection.

Re: Retaining Selections using bookmark or macro

udaya_kumar — Fri, 30 Aug 2013 10:28:16 GMT

Hi Andrea,

I tried this, but also it is not working.

I applied "Replace Bookmark" on sheet1 onleave sheet and "Apply Bookmark" on sheet1 onactivate sheet.

Is this correct?

Re: Retaining Selections using bookmark or macro

udaya_kumar — Fri, 30 Aug 2013 10:30:39 GMT

I tried this method, when i come to sheet1 from sheet2, all the selections are getting cleared.

Re: Re: Retaining Selections using bookmark or macro

Andrea_Ghirardello — Fri, 30 Aug 2013 15:27:02 GMT

Try the attached example...

Re: Retaining Selections using bookmark or macro

udaya_kumar — Mon, 02 Sep 2013 09:58:08 GMT

Hi Andrea,

Thanks for the file. It is working now for me.

But the bookmark is not working in Ajax/IE Plugin View.

Re: Retaining Selections using bookmark or macro

Andrea_Ghirardello — Mon, 02 Sep 2013 11:49:16 GMT

I'm sorry but it works for me in both environments.