I have created a job that creates table every day, stored into a folder on the qlikview server on the format FileName_YYYYMMDD. I now want to create a job that loads all the files "customer_YYYYMM10", so I can create a report where I compare the monthly development.
I tried something like this:
LET vMonthYear = Date(Today(),'YYYYMM');
LET vMonth = NUM(IF(Day(Today())>10,Month(Today()),Month(Today())-1),'00');
LET vDay = 10;
Do while vMonthYear < Today()
LOAD * from E:\Qlik\customer_vMonthYear$(vDay).qvd (qvd);
However, this doesnt work.. Can anyone please help me with this?