Show all dates in a table chart

drohm002 — Mon, 22 Nov 2021 17:14:10 GMT

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!

Re: Show all dates in a table chart

Or — Mon, 22 Nov 2021 17:55:32 GMT

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/1470637https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394

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

topic Re: Show all dates in a table chart in QlikView

Show all dates in a table chart

Re: Show all dates in a table chart