Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
eng19872
Creator
Creator
‎2019-06-06 08:35 AM

Generate Missing Dates with value Zero "0"

Hi,

Can you help me how to generate Missing Dates with value Zero "0". 

Available Data:

CalendarIdsValues
01.01.201711001
01.02.201712015
01.03.2017122
01.05.201711200
01.06.201711524
01.07.20171213
01.08.201713256
01.10.20171627
01.11.20171354
01.01.201711001
01.04.201911200
01.06.201911524
01.07.201910
01.08.201913256
01.09.20191627

 

 

Required Data / Desired Output:

CalendarIdsValues
01.01.201711001
01.02.201712015
01.03.2017122
01.04.201710
01.05.201711524
01.06.20171213
01.07.201713256
01.08.20171627
01.09.201710
01.10.20171627
01.11.201711007
01.12.201710
01.01.201910
01.02.201910
01.03.201910
01.04.201911200
01.05.201910
01.06.201911524
01.07.201910
01.08.201913256
01.09.20191627
01.10.201910
01.11.201910
01.12.201910
Labels (1)
Labels
886 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2019-06-06 08:44 AM

Have you seen this already?

Generating Missing Data

878 Views
0 Likes