Skip to main content

Qlik

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
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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: 
Marie201931
Contributor
Contributor
‎2020-08-19 03:43 PM

Date holes not populated even Master Calendar was associated.

There is a date hole in my fact table. I created a master calendar and associated a key date between the fact table and calendar table. I created a list table and saw the date hole was there (blue pen circled). That confirmed the master calendar worked. However, when I use the MonthYear as the dimension to create charts, the missing date didn't display (red pen circled). I went to Property and unchecked the suppress null and missing value selection. It still didn't work.

Capture3.PNG

Capture4.PNG

 

What might be the issue? Thank you for your help.

Marie

 

230 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2020-09-03 09:41 AM

Going to need QVW in order to assist on this one.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
183 Views
0 Likes