topic Re: ValueLoop in QlikView

ValueLoop

AmCh — Tue, 09 Mar 2021 12:40:16 GMT

Hello all,

I would like to use the ValueLoop with non-decimal increment.

Since this is not possible with ValueLoop, is there another alternative?

Many thanks in advance.

Yours sincerely,

Amor

Re: ValueLoop

Or — Tue, 09 Mar 2021 12:43:01 GMT

What sort of increment are you looking to use, exactly?

If your list of values isn't too long, you could just use ValueList(). Otherwise, you'd probably want to generate the values in your script using a loop.

Re: ValueLoop

AmCh — Tue, 09 Mar 2021 12:54:00 GMT

My list of values is too long.
Basically, a non-decimal incrementing is possible with do while loop. How can I then create a list with this loop in the script?

Many thanks in advance.

Re: ValueLoop

Or — Tue, 09 Mar 2021 13:05:37 GMT

Set vValue = 10;

for i=1 to 99

Set vValue = vValue + pi()/e(); /* Your increment goes in this line*/

Load $(vValue) as SyntheticDimension

Autogenerate(1);

You could probably do this more efficiently with just autogenerate and the row number, but since I'm not sure exactly what sort of increment you're trying to work with, it's hard to say.