Discussion Board for collaboration on QlikView Scripting.
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.
I suppose I should write these with the correct format
For i=1 to vCounterMax
For i=1 to peek(Column, 0)
For i=1 to Peek('Column',0, 'Table')
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:
For i = 1 to >>>>>><<<<<<
The part following the 'to' does not seem to get resolved to a number.
Both worked for me:
Let vCounterMax = Peek('Field',0,'Table');
For i = 1 to vCounterMax
For i = 1 to Peek('Field',0,'Table')
If you are using the variable approach, what does a TRACE of your variable show?
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?