topic for loop in qlikview with dates in QlikView

for loop in qlikview with dates

Sun, 07 Apr 2013 23:20:34 GMT

i have to do an extraction with date

i have right now something like this...

but it didnt work qlikview didnt show me errors and i dont know what happends

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

how i can do this?

jonathandienst — Mon, 08 Apr 2013 10:21:21 GMT

This should do the trick:

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

Hope that helps

Jonathan

Mon, 08 Apr 2013 17:55:50 GMT

Hi ,

Try the below code ...

Let TodayDate = fabs(Today());

Let FromDate=fabs( Date('01/01/2012','DD/MM/YYYY'));

Cartera_COP:

LOAD

Date($(FromDate)+recno()-1, 'DD/MM/YYYY') as "Date"

AUTOGENERATE $(TodayDate)-$(FromDate)+1;

Please let me know if there is anything .