Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinod
Creator
Creator

How to Generate missing Date

Hi All.

How to generate missing dates in QlikView. I have attached simple dataset for Reference.

Please any one give me solution.

Regards,

Vinod.

15 Replies
tush
Creator II
Creator II

Hi Vinod,

               Please reffer below link surely it will help,

Generate missing Dates

Thanks:-

Tushar

tresesco
MVP
MVP

Check if this document :Generating Missing Data In QlikView helps.

pooja_prabhu_n
Creator III
Creator III

Hi,

Please find the attached qvw file

Thanks,

Pooja

Anonymous
Not applicable

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);


ans.PNG

Vinod
Creator
Creator
Author

ID column should not be null, It is also filled with ID no-9000 related to date 06-09-2018 and 10-09-2018.

Vinod
Creator
Creator
Author

ID column should not be null, It is also filled with ID no-9000 related to date 06-09-2018 and 10-09-2018.

Anonymous
Not applicable

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);

answer.PNG

Vinod
Creator
Creator
Author

SORRY, I forget to tell you in my case it is 9000, but i want dynamic values.

Anonymous
Not applicable

Hi Vinod

Dynamic means : Like 1 to 100