topic How to create a Master Calendar for such date fields? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-Master-Calendar-for-such-date-fields/m-p/1210163#M626298 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I would like to add in a master calendar in my qlikview app. </P><P></P><P>In my orders table - there are OrderDate, Year, and other fields.</P><P></P><P>In my sales_target tabble there are Month, Year and other fields.</P><P></P><P>I dont know how to create a master calendar with such fields... </P><P></P><P>Rgds</P><P></P><P>Jim </P></BODY></HTML> Mon, 10 Oct 2016 23:26:17 GMT jim_chan 2016-10-10T23:26:17Z How to create a Master Calendar for such date fields? https://community.qlik.com/t5/QlikView/How-to-create-a-Master-Calendar-for-such-date-fields/m-p/1210163#M626298 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I would like to add in a master calendar in my qlikview app. </P><P></P><P>In my orders table - there are OrderDate, Year, and other fields.</P><P></P><P>In my sales_target tabble there are Month, Year and other fields.</P><P></P><P>I dont know how to create a master calendar with such fields... </P><P></P><P>Rgds</P><P></P><P>Jim </P></BODY></HTML> Mon, 10 Oct 2016 23:26:17 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Master-Calendar-for-such-date-fields/m-p/1210163#M626298 jim_chan 2016-10-10T23:26:17Z Re: How to create a Master Calendar for such date fields? https://community.qlik.com/t5/QlikView/How-to-create-a-Master-Calendar-for-such-date-fields/m-p/1210164#M626299 <HTML><HEAD></HEAD><BODY><P>With such fields? You mean with multiple dates in your app? May be see this</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Tue, 11 Oct 2016 00:52:00 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Master-Calendar-for-such-date-fields/m-p/1210164#M626299 sunny_talwar 2016-10-11T00:52:00Z Re: How to create a Master Calendar for such date fields? https://community.qlik.com/t5/QlikView/How-to-create-a-Master-Calendar-for-such-date-fields/m-p/1210165#M626300 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/205258">How to Create a Master Calendar with 3 Fact Tables</A></P><P></P><P>Hi Jim,</P><P></P><P>I had a similar scenario. check out the link above in addition to sunny's suggestion.</P><P></P><P>HTH</P></BODY></HTML> Tue, 11 Oct 2016 01:24:23 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Master-Calendar-for-such-date-fields/m-p/1210165#M626300 Anonymous 2016-10-11T01:24:23Z