Do while loop

Anonymous — Sun, 02 Aug 2015 10:40:50 GMT

Hi all,

I have problem with do while loop .Its not quiting the loop even after meeting the condition.

It is continuously running the loop.

Here is my code

do while vweekstart<=vweekend

let vnewweekend =date(date#(vweekstart)+6);

fct_sales:

Select * from FctSales where DATE_KEY BETWEEN '$(vweekstart)' AND '$(vnewweekend)'

let file = Year(date#(vweekstart))&week(date#(vweekstart));

trace file= $(file);

//Store and Drop Table

STORE FCT_DAILY_SALES INTO [./Qvd/$(file).QVD];

DROP TABLE FCT_SALES;

let vweekstart = date(date#(vweekstart)+7);

LOOP;

Re: Do while loop

marcus_sommer — Sun, 02 Aug 2015 10:59:16 GMT

I think you should put some trace-statements within your which return your do while variables, especially something like vweekstart - vweekend to see could it be calculated. In general it's recommended to use for each calculation or comparison numeric values, maybe something like this:

do while num($(vweekstart)) <= num($(vweekend))

and uncomment your select-load for the testings.

- Marcus

topic Re: Do while loop in QlikView

Do while loop

Re: Do while loop