How to Show Dates With No Data

[#1]

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?

[Anonymous]

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

[#3]

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?

[Anonymous]

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

[#5]

Thank you. I'll try this.