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?
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?