Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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