Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
Not applicable

How to Show Dates With No Data

Hi,

I hope someone can help with this question. I have a table showing daily sales side by side with the daily quota. The quota column is designed to total up to a MTD quota. I've just realized for days where there is no sale activity, that day is left off my table completely. Naturally, this affects ho my MTD quota is calculated. Can anyone offer a suggestion on how I can fix this?

Tags (1)
4 Replies
mov
Esteemed Contributor III

Re: How to Show Dates With No Data

Create a calendar in the script - a table that contains all dates in a specified range.

Not applicable

Re: How to Show Dates With No Data

Thank you. I should have mentioned, I'm using SQL for the table script. I added a calendar table to the original SQL. Do I have to add a calendar table using Qlikview Scripting language?

mov
Esteemed Contributor III

Re: How to Show Dates With No Data

Yes, in QlikView script, see an example (you can find many more):
http://community.qlik.com/docs/DOC-1310


Not applicable

Re: How to Show Dates With No Data

Thank you. I'll try this.