topic Select in Field in QlikView

Select in Field

Wed, 06 Jan 2016 17:58:36 GMT

I am trying to have my Search String (seen below), in the Select in Field action at the bottom of this object button, reference a variable that is affected/updated by the fields selected above it. That is, for the last action, I want to use an If statement evaluating the current value of the variable (vDolAmt), which dynamically changes given the fields that were selected by the actions above it. Given that actions in an object run top down, I would have thought this was possible, however, it does not seem to be so as qv thinks the value is 0 when evaluating, and thus does not filter the 'Country' field. I tried to "Set Variable" before I reference it in the action below it in hopes of "refreshing" the variable value, but to no avail. Is there a way around this?

Re: Select in Field

Anonymous — Wed, 06 Jan 2016 18:15:56 GMT

Unfortunately Actions do not run in order from top to bottom.

In fact, one cannot guarantee the order they are run in. So one should never do any Actions that are dependent on other Actions having been run first.

Re: Select in Field

Anonymous — Wed, 06 Jan 2016 18:48:33 GMT

Bill,

That is very interesting. I have not had that experience, but I guess it depends on the kind of actions you do. Here is a link I found with more information that was helpful.

Re: Execution order of actions

Re: Select in Field

Wed, 06 Jan 2016 19:20:27 GMT

Thanks Mike, Christof's workaround did the trick