topic Re: For each loop does not work in QlikView

For each loop does not work

chriys1337 — Wed, 19 Apr 2017 10:50:12 GMT

Hi,

I am not sure where my mistake is, but QV script runs through but does not generate the table:

LET vL.Week=20;

For i = right(WeekName(today()),2) to $(vL.Week) // FOR 16 to 20
Selection_Table:
Load
left(WeekName(today()),4) & right(WeekName(today()),2) +IterNo()
as Selection;
next i

Re: For each loop does not work

Anonymous — Wed, 19 Apr 2017 10:52:32 GMT

where's your reference table?

or do you use autogenerate?

did you try an explicit noconcatenate?

Re: For each loop does not work

Anonymous — Wed, 19 Apr 2017 11:06:42 GMT

try:

Re: For each loop does not work

chriys1337 — Wed, 19 Apr 2017 11:30:16 GMT

This worked fine, it was the missing reference table. Also it is working with autogenerate, thank you!

SET vL.FutureWeek=right(WeekName(today()),2)+6;

For i = right(WeekName(today()),2) to $(vL.FutureWeek)
Selection_Table:
Load
left(WeekName(today()),4) & (right(WeekName(today()),2)+rowno()-1)
as Selection
AutoGenerate 1 ;
next i

Re: For each loop does not work

Anonymous — Wed, 19 Apr 2017 11:32:29 GMT

yes, you can't do a load on nothing...

... and iterno() only works for LOAD <-> while loops...