topic AW:Infinite loop Problem in QlikView

Infinite loop Problem

Fri, 21 May 2010 09:54:52 GMT

Hi,

I am executing the following code:

LET a = 1;

do while ($(a) <= 3)

LOAD

Department_Key,

BUDGET AS NBUDGET

RESIDENT Table

LET a = a + 1;

loop

---

This is rendering me an infinite loop.

Where am I goin wrong..pls help

Regards,

Rohit

Fri, 21 May 2010 10:01:42 GMT

I dont think you need $(a) in this case, as $(a) means to evaluate the expression, and your variable is not an expression, just a value.

Try first changing to DO WHILE a<=3

If this doesn't work then you might want to change the LET statements to SET statements, but I'm not sure you should need to do this.

biester — Fri, 21 May 2010 10:01:48 GMT

I think it should be:

do while (a <= 3)

Rgds,
Joachim