topic Re: Execution order of actions in QlikView

Execution order of actions

Tue, 03 Jan 2012 16:31:31 GMT

Is there any way to control the order that actions are run or should I go back to macros?

Execution order of actions

Miguel_Angel_Baeyens — Tue, 03 Jan 2012 16:38:05 GMT

Hi,

Within the same object (say, a button), actions are run from top to down, the first in the list of actions will run first, and so on. If you have some OnOpen triggered actions, this will run prior to any other action.

Is that what you were looking for?

Miguel

Re: Execution order of actions

Jason_Michaelides — Mon, 18 Jun 2012 11:00:45 GMT

Hi Miguel,

On this topic, I have a button that runs 3 actions:

1. Select in Field: Field=%PointInTime, Search string = (Daily*|MTD*|QTD|YTD)

2. Run a macro (enables/disables chart expressions)

3. Set Variable: Variable=vPiT_Choices_LastSet, Value = Concat(DISTINCT %PointInTime,',')

Looking at this you would expect the variable in step 3 to set to the result of the Select in Field action (step 1) which is what I want. However, you have to click the button twice for this to work. My tests are showing that the result of step 1 is ignored by step 3.

Any ideas?

Thanks,

Jason

Re: Execution order of actions

Tue, 25 Sep 2012 20:31:42 GMT

Hello

I have the same issue, I need to click my button twice for all 3 actions to execute. Were you able to resolve this?

Thanks,

Ben

Re: Execution order of actions

Jason_Michaelides — Thu, 27 Sep 2012 11:52:17 GMT

Afraid not. It's a bug in QV where a string of actions doesn't respect its own field changes. I had to split them into two places.

Re: Execution order of actions

Thu, 27 Sep 2012 22:51:22 GMT

Jason, by splitting it into 2 places, do you have 2 seperate buttons now or did you do something else. Thanks.

Re: Execution order of actions

rwunderlich — Fri, 28 Sep 2012 00:21:39 GMT

The doc does say that "The actions will be executed in the order in which they appear in the list.", but I've never had any luck getting them to execute serially.

-Rob

Re: Execution order of actions

Jason_Michaelides — Fri, 28 Sep 2012 07:11:45 GMT

I think so. Something like a Save and an Update/Apply button.

Re: Execution order of actions

ChristofSchwarz — Fri, 13 Sep 2013 08:45:00 GMT

There seems to be an undocumented rule like "Set before select" ... call it a bug or not ... If you have a block of actions within a button or textbox or trigger and intend to use a SET VARIABLE action after a SELECT-action (like SELECT FIELD or CLEAR FIELD or others....) and you expect to get the result from that selection into the variable, you will NOT get it. The variable will be set before the selection change becomes effective, no matter in which sequence you put it.

This is the status until today (QV 11.2 SR3)

WORKAROUND - HELP WITH ANOTHER TRIGGER (Not for Ajax!)

If you like to get a field value into a variable after you changed the selection in the same action, you will need the following "ingredients":

a new field, not linked to any other data,
A on-select trigger on that new field
The action itself will first define, a) which variable to change and b) the expression to execute into two temp-variables and
then set the new field (the one with a trigger) to a dummy value.
The on-select field trigger, finally, sets the expression (as given in a temp variable) into the desired variable (whose name was also given in a temp variable).

The point of time, when the on-select field trigger is executed, is then indeed AFTER the selections made by the action button and will deliver the desired result. It is demonstrated on the below example, where the green action button

captures the current selection of FieldX into variable A
changes the FieldX selection
captions the new selection of FieldX into variable B

See https://dl.dropboxusercontent.com/u/92495732/Action%20Set%20Variable.qvw

I have to admit, that the Ajax Client only executes one action block at a time. If one action sets a field, which has a trigger on it, Ajax client (or Web preview) does not execute the trigger. If you manually change the field (the one with the trigger) in Ajax, the trigger will be fired. So: My above example is not Ajax-ready!

Re: Execution order of actions

mark_casselman — Sun, 10 Nov 2013 17:34:51 GMT

Same issue here.

Made 3 actions on a button to switch the contents of 2 variables A and B:

- set variable 'temp' to the value of 'A'

- set the variable 'A' to the value of variable 'B'

- set the variable 'B' to the value of variable 'temp'

But, this doesn't work.

I think it's a 'bug'.

Any other solution to switch variable value between 2 varaiables ?

Re: Execution order of actions

ChristofSchwarz — Mon, 11 Nov 2013 13:37:30 GMT

No, it is not a bug. It works different. To switch variables A with B, simply assign

Variable A = Variable B
Variable B = Variable A

No 3rd Variable in the game. It has to do with the time when the new settings become effective. As long as the action block is being executed (has not reached the last action), none of the changes on fields and values become active. They are "prepared" in a separate state, which at the end gets applied. Therefore, the above actions will do.

-best regards

Re: Execution order of actions

mark_casselman — Mon, 11 Nov 2013 22:39:02 GMT

Thanks Christof,

I tried your solution and it works ! Thanks for that.

I was too much confused with the promote and demote options. But now I understand that they do not apply on the execution order (it still is confusing in my humble opinion).

Re: Execution order of actions

Mon, 11 Nov 2013 23:20:15 GMT

Should give him an a usefull or correct answer. And thanks Christof!

Re: Execution order of actions

Anonymous — Fri, 02 Oct 2015 13:25:23 GMT

Has there been any updates (planned or otherwise) that would fix this issue?

Re: Execution order of actions

suman_731995 — Thu, 18 Apr 2019 08:29:27 GMT

Is there any update related to this Bug in SR 12 - Nov 2017 release?

Thanks,

Suman

Re: Execution order of actions

rwunderlich — Thu, 18 Apr 2019 09:19:20 GMT

I don't believe there is any identified bug here. The effect of actions are intentionally isolated until the action block ends to avoid endless cascading.

-Rob

Re: Execution order of actions

ramonarcusa36 — Thu, 25 Mar 2021 15:18:50 GMT

Hi Rob and everyone!

Do you guys know if this behavior also applies to Qlik Sense?

I have set a few actions to be executed when clicking a button, and I'm getting unexpected results. I think it has to do with Qlik Sense not waiting until finishing an action to start the next one.

Is all this related to the multithreaded nature of both QlikView and Qlik Sense?

Thanks!