topic Re: Bookmark & Trigger precedence in QlikView

Bookmark & Trigger precedence

Wed, 17 Jul 2013 19:32:43 GMT

Hi All,

I have a question regarding Qlikview precedence for applying bookmark and triggers simultaneously.

Could someone please explain me if I have a bookmark (including state change property) and a trigger in a qvw, what will be the precedence of these actions?

The best example to check the precedence would be a bookmark having state change property selected and a OnLeaveSheet trigger.

I have attached a qvw which has two tabs and some sample data. I have also created a bookmark called B2, which was created on Main Sheet and having state change property checked. The other tab (Copy of Main) has OnActivateSheet and OnLeaveSheet trigger which is Clear All trigger.

Now If i go to second sheet and select B2 bookmark. It will open Main sheet but won't apply its selection.

I figured out the sequence and it is , once i click bookmark 'B2', Qlikview go to Main sheet and starts applying its selection but after completing bookmark job it checks that there was a OnLeaveSheet trigger which needs to be applied as the sheet has been changed. So then it apply this trigger, which clears the bookmark selections.

In the above situation I would like your thought about the default behaviour of Qlikview. In my openion if a bookmark has state change property and is triggering OnLeaveSheet trigger, when user select the bookmark then Qlikview should apply OnLeaveSheet trigger first and then the bookmark?

Thanks,

Anosh Nathaniel

Re: Bookmark & Trigger precedence

Gysbert_Wassenaar — Thu, 18 Jul 2013 06:02:13 GMT

The bookmark doesn't trigger the OnLeave or OnActivate sheet trigger. The user does that by changing to another sheet. That's what's clearing the selection. The bookmark has nothing to do with it. The Clear All action really simply clears all selections.

Re: Bookmark & Trigger precedence

Mon, 22 Jul 2013 18:46:58 GMT

Hi Gysbert,

Thanks for your reply. When a bookmark is created with the state change property then it saves the tab id also on which this bookmart is being created.

Now if user who is on another tab applys this bookmark, Qlikview opens that tab first and applys the bookmark selections.

Regards,

Anosh

Re: Bookmark & Trigger precedence

Gysbert_Wassenaar — Tue, 23 Jul 2013 06:45:29 GMT

Ah, I see what you mean. I think the bookmark activates the bookmarked state of both fields and layout simultaneously, not consecutively. The OnLeaveSheet trigger fires after that and clears the selections.

Re: Bookmark & Trigger precedence

Wed, 24 Jul 2013 13:22:25 GMT

Yes Gysbert, you are correct, but i don't want to clear the selections which bookmark has made and i think this should be the ideal behaviour . What do you think?

Re: Bookmark & Trigger precedence

Gysbert_Wassenaar — Wed, 24 Jul 2013 13:41:57 GMT

I don't understand why you have the Clear All action on the OnLeaveSheet trigger. It looks useless to me since your bookmark replaces the current selections anyway. If you remove that you should have the behaviour you want.

Re: Bookmark & Trigger precedence

Thu, 01 Aug 2013 14:36:15 GMT

Hi Gysbert,

Thanks for your reply. I have a need to clear all the selections and then apply tab specific selections on each tab when it is opened. This is required for multiple reason:

I have to lock few field values on each tab so tha user cannot change it
Apply some selections so that user can see default view when they open the tab
There are several other reason to do that

Even if I delete the Clear All action on OnLeaveSheet and apply it on OnActivateSheet, then also I am facing the same problem.

Re: Bookmark & Trigger precedence

Tue, 16 Dec 2014 19:57:35 GMT

The bookmark doesn't trigger the OnLeave or OnActivate sheet trigger. The user does that by changing to another sheet. That's what's clearing the selection. The bookmark has nothing to do with it. The Clear All action really simply clears all selections.

Gysbert Wassenaar

Hi Gysbert,

i have a similar problem:

I want to activate a bookmark (wich includes layout and variables) by its link (send by mail) on access point,

but it fires the onactivatesheet triggers like clear all and set variables....

It's a bug???

Re: Bookmark & Trigger precedence

saimahasan — Sun, 22 Jan 2017 14:53:13 GMT

Me too facing similar issue when trying to select the bookmark it shows up the fields which are used in "Select in Field" trigger and their values as null...

Please can anyone suggest on it??