topic Re: Where to insert the Master Calendar? in QlikView https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188360#M627929 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Tue, 20 Sep 2016 08:15:50 GMT MK_QSL 2016-09-20T08:15:50Z Where to insert the Master Calendar? https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188359#M627928 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following problem. I have three tables with 3 dates (see image 1).</P><P><IMG __jive_id="137984" alt="Data_model_1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137984_Data_model_1.PNG" style="max-width: 620px; height: auto;" /></P><P><SPAN style="text-decoration: underline;">I want to create a report with shows in one table the following points:</SPAN></P><UL><LI>How many new customers I get per month?</LI><LI>How customers ordered per month?</LI><LI>How many customers paid per month?</LI></UL><P></P><P>For that my plan is to change the data model to this:<IMG __jive_id="137985" alt="Data_model_2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/137985_Data_model_2.PNG" style="height: 164px; width: 620px;" /></P><P>But this designs is not perfect. The user has still to select 2 Shops_ID to change the table. Any suggestion for a better solution?</P></BODY></HTML> Tue, 20 Sep 2016 08:09:51 GMT https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188359#M627928 qlikconsultant 2016-09-20T08:09:51Z Re: Where to insert the Master Calendar? https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188360#M627929 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Tue, 20 Sep 2016 08:15:50 GMT https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188360#M627929 MK_QSL 2016-09-20T08:15:50Z Re: Where to insert the Master Calendar? https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188361#M627930 <HTML><HEAD></HEAD><BODY><P>Perhaps this discussion helps: <A href="https://community.qlik.com/thread/64619">Master calendar</A></P></BODY></HTML> Tue, 20 Sep 2016 08:22:08 GMT https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188361#M627930 Gysbert_Wassenaar 2016-09-20T08:22:08Z Re: Where to insert the Master Calendar? https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188362#M627933 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>have you seen this</P><P></P><P><A href="https://community.qlik.com/docs/DOC-6502">Handling Multiple Calendars.qvw</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-5834">Linking to two or more dates</A></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Tue, 20 Sep 2016 15:06:20 GMT https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188362#M627933 agomes1971 2016-09-20T15:06:20Z Re: Where to insert the Master Calendar? https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188363#M627936 <HTML><HEAD></HEAD><BODY><P>Thanks&nbsp; for the tips. I think I found a solution. Testing at the moment.</P></BODY></HTML> Wed, 21 Sep 2016 07:48:56 GMT https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188363#M627936 qlikconsultant 2016-09-21T07:48:56Z Re: Where to insert the Master Calendar? https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188364#M627939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>then post you're solution here that would be nice!</P><P></P><P>Regards</P><P></P><P>André Gomes</P></BODY></HTML> Wed, 21 Sep 2016 10:34:02 GMT https://community.qlik.com/t5/QlikView/Where-to-insert-the-Master-Calendar/m-p/1188364#M627939 agomes1971 2016-09-21T10:34:02Z