topic How can I do a Master Calender for multiple date fields in a single original table? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-do-a-Master-Calender-for-multiple-date-fields-in-a/m-p/1047442#M639068 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How can I do a Master Calender for multiple date fields in a single original table?</P><P></P><P>Example:</P><P></P><P>TableA:</P><P>OrderID,</P><P>ItemNo</P><P>Quantity</P><P>OrderDate,</P><P>Value,</P><P>DueDate,</P><P>Discount</P><P>From TableA</P><P></P><P>The above table has two date fields OrderDate and DueDate.</P><P></P><P>I assume doing two Master Calenders, one for each date field would not be a great solution.</P><P></P><P>Are there any better alternatives?</P></BODY></HTML> Mon, 04 Apr 2016 12:31:48 GMT jblomqvist 2016-04-04T12:31:48Z How can I do a Master Calender for multiple date fields in a single original table? https://community.qlik.com/t5/QlikView/How-can-I-do-a-Master-Calender-for-multiple-date-fields-in-a/m-p/1047442#M639068 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How can I do a Master Calender for multiple date fields in a single original table?</P><P></P><P>Example:</P><P></P><P>TableA:</P><P>OrderID,</P><P>ItemNo</P><P>Quantity</P><P>OrderDate,</P><P>Value,</P><P>DueDate,</P><P>Discount</P><P>From TableA</P><P></P><P>The above table has two date fields OrderDate and DueDate.</P><P></P><P>I assume doing two Master Calenders, one for each date field would not be a great solution.</P><P></P><P>Are there any better alternatives?</P></BODY></HTML> Mon, 04 Apr 2016 12:31:48 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-a-Master-Calender-for-multiple-date-fields-in-a/m-p/1047442#M639068 jblomqvist 2016-04-04T12:31:48Z Re: How can I do a Master Calender for multiple date fields in a single original table? https://community.qlik.com/t5/QlikView/How-can-I-do-a-Master-Calender-for-multiple-date-fields-in-a/m-p/1047443#M639070 <HTML><HEAD></HEAD><BODY><P>Look at Canonical date concept: <A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Mon, 04 Apr 2016 12:39:41 GMT https://community.qlik.com/t5/QlikView/How-can-I-do-a-Master-Calender-for-multiple-date-fields-in-a/m-p/1047443#M639070 sunny_talwar 2016-04-04T12:39:41Z