Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

Retaining Selections using bookmark or macro

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?

6 Replies
Andrea_Ghirardello

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.

udaya_kumar
Specialist
Specialist
Author

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?

udaya_kumar
Specialist
Specialist
Author

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

Andrea_Ghirardello

Try the attached example...

udaya_kumar
Specialist
Specialist
Author

Hi Andrea,

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

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

Andrea_Ghirardello

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