topic Variables in a for Loop in QlikView

Variables in a for Loop

Thu, 14 Apr 2011 14:19:33 GMT

hi I have two variables

Let vCurWeek = replace(WeekName(Today()), '/', '');
Let vLastWeek = Replace(WeekName(Today()-7), '/', '');

which gives me vCurWeek=201115 and vLastWeek=201114

now I want a loop

For i= 0 to 'End of period'

That means for Example if I consider 4 weeks[201114-201117)

How to use that variable in a loop like

For i= 0 to ($(vLastWeek)+4)-1

....

Next i

This does not work. Any idea?

Regards

Sravan

fosuzuki — Thu, 14 Apr 2011 17:24:16 GMT

Hi Sravan,

I'm not sure if I understood you, but the solution seems to be:

For i= $(vLastWeek) to ($(vLastWeek)+3)

....

Next i

Is this what you need?

Regards,

Fernando

Fri, 15 Apr 2011 09:37:22 GMT

hi Fernando,

That was easy. Thanks! Sometime small things are overseen, I am trying on this.

http://community.qlik.com/forums/t/44199.aspx

can you help me realise?

Thanks once again.

Regards

Sravan

fosuzuki — Fri, 15 Apr 2011 11:50:51 GMT

Hi Sravan,

glad to help.

One thing you must have in mind is when your end of period goes to the next year.

For example 201150 to 201202. The for loop wont work correctly, and you'll need no treat these situations.

Regards,

Fernando