topic Re: For - Next parameter using variables? in QlikView

For - Next parameter using variables?

jackhertel — Sat, 10 Feb 2018 02:50:08 GMT

Can I use a variable, expression or a Peek for the constraints in a For Next

i.e. For 1 to vCounterMax or

For 1 to peek(Column, 0)

to define a loop. It does not seem to resolve either case.

Re: For - Next parameter using variables?

jackhertel — Sat, 10 Feb 2018 03:07:56 GMT

I suppose I should write these with the correct format

For i=1 to vCounterMax

For i=1 to peek(Column, 0)

Re: For - Next parameter using variables?

Anil_Babu_Samineni — Sat, 10 Feb 2018 05:45:42 GMT

Perhaps this?

For i=1 to Peek('Column',0, 'Table')

Re: For - Next parameter using variables?

jackhertel — Sat, 10 Feb 2018 13:06:10 GMT

Thank you Aniil,

But no luck. It does not seem to try to resole the Peek or a Variable at all.

I get an error message window that has:

Syntax error

For i = 1 to >>>>>><<<<<<

The part following the 'to' does not seem to get resolved to a number.

Re: For - Next parameter using variables?

swuehl — Sat, 10 Feb 2018 13:58:14 GMT

Both worked for me:

Let vCounterMax = Peek('Field',0,'Table');

For i = 1 to vCounterMax

TRACE $(i);

For i = 1 to Peek('Field',0,'Table')

TRACE $(i);

If you are using the variable approach, what does a TRACE of your variable show?

Re: For - Next parameter using variables?

Anil_Babu_Samineni — Sat, 10 Feb 2018 14:11:42 GMT

The only thing, I can think about your Peek() may stores String which 1 to Some String which is false? Can you screenshot the image of Trace as Stefan said?