Discussion Board for collaboration on QlikView Scripting.
First one is actual data, the second is the required result.
let Start = floor(makedate(1971,01,01));let End = floor(today())+1;
let NoOfDays = End - Start;
Cal1:Load$(Start)+recno()-1 as Dateautogenerate$(NoOfDays);
Cal2:LoadYear(Date) as Yearresident Cal1;
DROP Table Cal1;
A:LOAD Year, SalesFROMSNO.xls(biff, embedded labels, table is Sheet1$);
Final:Left Join(Cal2)LoadYear, Sales,Year as Year1resident A;
Drop Table A;
All kind of suggestions/solutions are most welcome.
Go to Solution.
attach is an example
Thanks a lot... It's working fine.