Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
How to generate missing dates in QlikView. I have attached simple dataset for Reference.
Please any one give me solution.
Regards,
Vinod.
Check if this document :Generating Missing Data In QlikView helps.
Hi,
Please find the attached qvw file
Thanks,
Pooja
Hi Vinod,
Try Below Code I got result like below screenshot.
Directory;
LOAD
ID,
if(len(Date)=0,date(Previous(Date)+1,'DD-MM-YYYY'),DATE(Date,'DD-MM-YYYY')) as Date
FROM
[..\Downloads\DateData.xlsx]
(ooxml, embedded labels, table is Sheet1);
ID column should not be null, It is also filled with ID no-9000 related to date 06-09-2018 and 10-09-2018.
ID column should not be null, It is also filled with ID no-9000 related to date 06-09-2018 and 10-09-2018.
HI Vinod,
Try below.
Directory;
LOAD
if(len(ID)<0 or IsNull(ID) ,9000,ID)as ID,
if(len(Date)=0,date(Previous(Date)+1,'DD-MM-YYYY'),DATE(Date,'DD-MM-YYYY')) as Date
FROM
[..\Downloads\DateData.xlsx]
(ooxml, embedded labels, table is Sheet1);
SORRY, I forget to tell you in my case it is 9000, but i want dynamic values.
Hi Vinod
Dynamic means : Like 1 to 100