topic Sheet Properties - Triggers in QlikView

Sheet Properties - Triggers

priyarane — Thu, 12 Mar 2015 15:13:45 GMT

Hi Experts,

I want clear all the in current selections, if I go for further sheets. But my selections should be there if I come back to my sheet.

ex:

Sheet1 - Current selections - Dim:A

Once I leave from Sheet 1 then it should not be there on Sheet 2. if again, come back to sheet 1 current selections should be the same

Sheet2

Re: Sheet Properties - Triggers

alex_millan — Thu, 12 Mar 2015 15:16:35 GMT

Hi Priya,

Why not to configure Sheet2 in a different state than Sheet1? Would that suit to your requirements?

That would allow you to make a different selections in Sheet2 that wouldn't affect to Sheet1 using 'Alternate States'

Regards

Re: Sheet Properties - Triggers

Gysbert_Wassenaar — Thu, 12 Mar 2015 15:18:43 GMT

Use bookmarks. Create a bookmark first. When you want to leave the sheet use a Replace Bookmark as the first action and an Activate Sheet action as the second and finally a Clear All action. When you want to return to the sheet you can use the Activate Bookmark action and then the Activate Sheet again.

Re: Sheet Properties - Triggers

sorrakis01 — Thu, 12 Mar 2015 15:23:55 GMT

Yes,

Create a bookmark.

Re: Sheet Properties - Triggers

priyarane — Thu, 12 Mar 2015 19:49:27 GMT

Hi Gysbert,

In my case, I have 4 sheets and created 4 buttons on all the sheets and added the actions on 4 buttons as active sheet.