topic Run part of the code with variable control in QlikView

Run part of the code with variable control

Thu, 26 Mar 2015 09:31:48 GMT

I have a dimensions and facts.
I don't want to execute the dim's part (create qvd for each dim) every interval, only every 3 intervals.
so my idea was to create a counter variable (if variable >3 run the dim's part).
any advise how to do that?

is it possible to pass variable from management console?

Re: Run part of the code with variable control

marcus_sommer — Thu, 26 Mar 2015 11:56:00 GMT

You could use something like this directly or outsourced as include-variable:

if $(vIntervalCounter) < 3 then

let vIntervalCounter = $(vIntervalCounter) + 1;

exit script;

else

let vIntervalCounter = 0;

end if

....

// Your Load-Statements

- Marcus

Re: Run part of the code with variable control

Thu, 26 Mar 2015 16:02:48 GMT

Thanks,
what is the best source to use for save the variable?

is it possible to pass variable from management console?

Re: Run part of the code with variable control

marcus_sommer — Thu, 26 Mar 2015 16:52:12 GMT

I'm not sure but I believe you couldn't pass such variables from the qmc - maybe the publisher had here more options. But you could generate such variable externally and store it in a textfile which could be load as include-variable and then use a logic similar to the above mentioned.

- Marcus