topic Loop using new variables in QlikView

Loop using new variables

zagzebski — Mon, 05 Jan 2015 00:23:37 GMT

I don't how to accomplish the following. I want to take a table like the one below and loop through to create multiple tables each utilizing a different where clause based on dates. the first where clause would be like below, then MonthYear >=201002, then MonthYear >=201003, and so on. Somehow use a variable in where clause?Any ideas on a good method to accomplish this?

For i = 1 to 50

SalesbyRange:

Select *

From Resident Sales

where MonthYear >=201001;

Thanks in advance,

Steve

Re: Loop using new variables

Mon, 05 Jan 2015 01:10:13 GMT

don't know what you are trying to accomplish but your loop would be:

LET _MyStart = 201000;

SalesbyRange:

FOR _i = 0 to 50;;

LOAD * Resident Sales WHERE MonthYear >= $(_MyStart)+$(_i);

NEXT _i;

Re: Loop using new variables

zagzebski — Mon, 05 Jan 2015 14:58:52 GMT

Thanks Mario. This is a good start for me to get this accomplished!

Steve