topic Re: Master Calendar with Two Fact Tables in QlikView

topic Re: Master Calendar with Two Fact Tables in QlikView https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734555#M675251 <HTML><HEAD></HEAD><BODY><P>Also see:</P><P><SPAN>Qlikview Cookbook: Tutorial - Using Common Date Dimensions </SPAN><A class="jive-link-external-small" href="http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/">http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/</A></P><P></P><P>for a tutorial on handling multiple fact dates.</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://robwunderlich.com">http://robwunderlich.com</A></P></BODY></HTML> Tue, 08 Jul 2014 21:03:12 GMT rwunderlich 2014-07-08T21:03:12Z Master Calendar with Two Fact Tables https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734553#M675249 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is it possible to create a Master Calendar that can work between two fact tables?  See attached data model.  I have Sales Order and Invoice tables that both contain transaction dates.  I would like to create one Master Calendar that has a Year and Month dimension so I can have a List Box for Year and Month respectively.  </P><P></P><P>Thank you in advance for any information on this.  </P></BODY></HTML> Tue, 08 Jul 2014 20:17:40 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734553#M675249 asmithids 2014-07-08T20:17:40Z Re: Master Calendar with Two Fact Tables https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734554#M675250 <HTML><HEAD></HEAD><BODY><P>I would have several calendars. <EM><STRONG style="text-decoration: underline;">And</STRONG></EM> one canonical date for all dates.</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date">http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date</A></P><P></P><P>HIC</P></BODY></HTML> Tue, 08 Jul 2014 20:30:34 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734554#M675250 hic 2014-07-08T20:30:34Z Re: Master Calendar with Two Fact Tables https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734555#M675251 <HTML><HEAD></HEAD><BODY><P>Also see:</P><P><SPAN>Qlikview Cookbook: Tutorial - Using Common Date Dimensions </SPAN><A class="jive-link-external-small" href="http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/">http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/</A></P><P></P><P>for a tutorial on handling multiple fact dates.</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://robwunderlich.com">http://robwunderlich.com</A></P></BODY></HTML> Tue, 08 Jul 2014 21:03:12 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734555#M675251 rwunderlich 2014-07-08T21:03:12Z Re: Master Calendar with Two Fact Tables https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734556#M675252 <HTML><HEAD></HEAD><BODY><P>Thank you Henric and Rob for the information!  I will review all of this documentation.  </P></BODY></HTML> Wed, 09 Jul 2014 12:11:09 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/734556#M675252 asmithids 2014-07-09T12:11:09Z Re: Master Calendar with Two Fact Tables https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/1814992#M1212924 <P>Hello <SPAN>rwunderlich,</SPAN></P><P><SPAN>I've followed your guide but I still have an issue in my model... It seems that my "Month" dimension (which is "Mese") is not working. </SPAN></P><P><SPAN>I've showed in 3 Pivot tables my situation. Could you have a look please?</SPAN></P><P><SPAN>Thank you!</SPAN></P> Mon, 14 Jun 2021 18:04:29 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-with-Two-Fact-Tables/m-p/1814992#M1212924 danimarc12 2021-06-14T18:04:29Z