topic Re: Retain selections - Macro help in QlikView

Retain selections - Macro help

tamilarasu — Mon, 20 Jul 2015 06:11:12 GMT

I am using system field ($Field) in two sheets. Whenever the user do some selections in a sheet , it affects the other sheet as well. I want to retain (store the selections in a variable) the selections for two sheets and when switch back it should be restored. For example, I have two sheets named as "Sheet1" and "Sheet2". If the user made some selections in sheet1 and go to the sheet2, then the selections (From sheet1) must be stored in a variable. If the user switch to the sheet1 again, the selections should be fetched from the variable. Similarly for the sheet2.

Can anyone provide me the code.!!!!

Thanks in advance

P.S: I don't want to use alternate state.

Re: Retain selections - Macro help

Gysbert_Wassenaar — Mon, 20 Jul 2015 08:48:00 GMT

Use bookmarks. Create one bookmark for each sheet. Add a Replace Bookmark action to the OnLeave sheet trigger to save the selections of the sheet. Add a Apply Bookmark action to the OnActivate sheet trigger to restore the selections from the bookmark for the sheet.

Re: Retain selections - Macro help

tamilarasu — Wed, 29 Jul 2015 03:33:48 GMT

I have tried the above and it's working fine in my desktop. When I moved the application to access point, it seems replace bookmark not working. What could be the problem. ?

Re: Retain selections - Macro help

b_garside — Thu, 10 Nov 2016 19:16:08 GMT

This works flawlessly. Thanks for this idea. Glad I found this post!

I really did not want to use variables for multiple fields.

Re: Retain selections - Macro help

marcus_sommer — Fri, 11 Nov 2016 05:24:55 GMT

Maybe this might be helpful: Tracking the historical selections.

- Marcus

Re: Retain selections - Macro help

tamilarasu — Fri, 11 Nov 2016 05:53:52 GMT

Old thread . Anyway, thank you Markus. I have already read the above link .