Show all dates in a table chart

[drohm002]

Hi, please see the table below.  How would I get dates to show up for which there is no number?  The right column is counting cases.  11/1/2020 had 0 cases, but it doesnt populate with a 0.  I want it to show a "0" in the right column for 11/1/2020.  How would i make that appear? thank you!

[Or · Accepted solution]

If data for this date exists and the issue is just that there's 0 of whatever you're counting, you can uncheck the suppress zero/null values box.

If the date doesn't exist in the data at all, you'll need to fill it in using your script. Have a look at:

https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/ba-p/14706...

And for master calendar specific, https://qlikviewcookbook.com/2015/05/better-calendar-scripts/