Discussion Board for collaboration regarding Qlik DataMarket.
Hi guys, I am new and having trouble when trying to execute this report. I got one excel file that have table as below,
and I want to segregate the startDate and EndDate into daily (Line by Line) like shown below,
Please help me out because its very urgent.
LOAD Date(StartDate + IterNo() - 1) as StartDate,
Date(StartDate + IterNo() - 1) as EndDate,
While StartDate + IterNo() - 1 <= EndDate;
(html, codepage is 1252, embedded labels, table is @1);
Hi Sunny,Appreciated your reply. i try your code n succeed but somehow the result/date continues generate until year 9999. I just want the date display depends on existing file.
its look like this:
May be the max date in your database is 9999 or something is mis-specified to be the year 9999. Would you be able to check your date?