topic How to Show Dates With No Data in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784408#M2139 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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?</P></BODY></HTML> Tue, 13 Jan 2015 19:52:24 GMT 2015-01-13T19:52:24Z How to Show Dates With No Data https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784408#M2139 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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?</P></BODY></HTML> Tue, 13 Jan 2015 19:52:24 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784408#M2139 2015-01-13T19:52:24Z Re: How to Show Dates With No Data https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784409#M2140 <HTML><HEAD></HEAD><BODY><P>Create a calendar in the script - a table that contains all dates in a specified range.</P></BODY></HTML> Tue, 13 Jan 2015 19:58:24 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784409#M2140 Anonymous 2015-01-13T19:58:24Z Re: How to Show Dates With No Data https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784410#M2141 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 14 Jan 2015 00:50:39 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784410#M2141 2015-01-14T00:50:39Z Re: How to Show Dates With No Data https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784411#M2142 <HTML><HEAD></HEAD><BODY><P>Yes, in QlikView script, see an example (you can find many more):<BR /><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1310">http://community.qlik.com/docs/DOC-1310</A></P><P><BR /> </P></BODY></HTML> Wed, 14 Jan 2015 13:40:17 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784411#M2142 Anonymous 2015-01-14T13:40:17Z Re: How to Show Dates With No Data https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784412#M2143 <HTML><HEAD></HEAD><BODY><P>Thank you. I'll try this.</P></BODY></HTML> Thu, 15 Jan 2015 19:17:46 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-Show-Dates-With-No-Data/m-p/784412#M2143 2015-01-15T19:17:46Z