Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I haven't had much of a use for a master calendar in the past as I haven't had much for missing dates that we wanted to fill in. I decided to give it a shot and followed exactly what I found in a QlikView Developer booklet I received in training years ago. The problem is, it works, but it doesn't... my missing dates that don't have stats are not showing up. Spent the last day googling and testing things I found in the community to no avail... Could someone help me figure out the element I'm missing? I've attached a scrambled limited version of the report for an example.
tried in one of the expressions, table just turns to this...
I'm seeing why people choose to not use these Master Calendars as much, never had so many issues with something that seems like it should be working
Try the last count expression on a straight table with one dimension and see whether it works or not.
It has nothing to do with master calendar. It's because there is no data.
So we are trying to create missing dates and data.
No data correct, but the point from what I've seen for all of these Master Calendar articles is to fill in dates that are missing so they appear in charts and tables build in QlikView. They can show as zeros, but at least you see these dates charted
Uncheck "Suppress Zero-Values" in the Presentation pane of the object.
-Rob
I checked those, they are already unchecked.
Well, I know you found the YouTube video, but I wanted to give you the Design Blog post on the Master Calendar as well, as I thought it might be of some further help potentially, There are also lots of other posts, so feel free to backup a level on the URL and then search again for what you think you may need, there may be another post that will get you the missing piece there.
https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527
Regards,
Brett