Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
This should do the trick:
FOR i=Date#('01/01/2012','DD/MM/YYYY') to $(y)
Hope that helps
Jonathan
Hi
This should do the trick:
FOR i=Date#('01/01/2012','DD/MM/YYYY') to $(y)
Hope that helps
Jonathan
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 .