topic Re: how to implement a date loop in QlikView

how to implement a date loop

Sun, 07 Apr 2013 22:08:59 GMT

i have to do a extraction loop of with dates

something like

let y=today();

for i='01/01/2012' to $(y)

ExtractTable:

select

Store table into table_$(i).qvd;

drop table ExtractTable;

Next i

But i dont know whats wrong, qlikview didnt do anything.

how i do this??

sushil353 — Mon, 08 Apr 2013 05:23:33 GMT

Hi,

try this:

LET y=Today();

FOR i=Date('01/01/2012','DD/MM/YYYY') to '$(y)'

Cartera_COP:

//Query Statement

STORE * FROM Cartera_COP into ../01_Datos/Cartera_COP_$(i).qvd;

DROP Table Cartera_COP;

NEXT i