topic Re: How do Document Triggers really work? in QlikView

How do Document Triggers really work?

rittermd — Wed, 08 Apr 2015 13:23:32 GMT

I have a trigger that I have set for OnOpen in the Document Triggers that should give me the most current period as the default.

It is coded as =max(PERIOD)

It is not working.

The document always opens with the Period 201412 even though the latest period is 201512.

When the document was saved before being published 201412 was the choice. So it appears that something overrides the trigger.

The above is happening on my copy in development.

I am not getting the expected results on the Portal either.

So can someone hopefully explain what I might be doing wrong or if this is how it works?

Thanks

pokassov — Wed, 08 Apr 2015 13:29:47 GMT

Hi!

It looks strange you write Period and PERIOD. Are they the different fields?

Wed, 08 Apr 2015 13:33:35 GMT

On opening can add a trigger to clear all selections, before applying the new selection.

Action Type: Selection

Action: Clear All

Regards

jerrysvensson — Wed, 08 Apr 2015 14:36:02 GMT

OnOpen trigger doesn't (always) work in Ajax. If you are using Ajax as client and not plugin this could be your problem.

gradiske — Wed, 29 Apr 2015 17:56:38 GMT

After so many tries with document/sheet/field and variables triggers, i found a way to make this thing work.

Here's what i did.

Create a variable, ex: vOnOpen (set 0 or something else, it doesn't matter at this point)

At Document Event Triggers, OnOpen

Add a action to change the variable.
Something like
if(vOnOpen='1','0','1')

Now, on variable event trigger, choose vOnOpen and then add a OnChange Action
Here's where you put all the triggers you want.

It's weird, but for me, its working.