topic Calendar for two dates in QlikView https://community.qlik.com/t5/QlikView/Calendar-for-two-dates/m-p/1289271#M619536 <HTML><HEAD></HEAD><BODY><P>I have some sales data which contains two dates(actually multiple dates).&nbsp; and i would love to use the calendar for both dates.</P><P></P><P>I'm guessing i'm setting up my Master Calendar wrong.</P><P></P><P>I have attached an limited example. where both dates and the sales amount are shown.&nbsp; but since the invoice date and the order aren't always the same.&nbsp; I would love to have the pivot like it's shown. sales in all the monts, and the order intake in the same month.&nbsp; </P><P></P><P>I found this link <A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A>&nbsp;&nbsp; and I have tried implementing it.. but i must be missing and important point.&nbsp; </P></BODY></HTML> Mon, 27 Mar 2017 20:17:08 GMT Anonymous 2017-03-27T20:17:08Z Calendar for two dates https://community.qlik.com/t5/QlikView/Calendar-for-two-dates/m-p/1289271#M619536 <HTML><HEAD></HEAD><BODY><P>I have some sales data which contains two dates(actually multiple dates).&nbsp; and i would love to use the calendar for both dates.</P><P></P><P>I'm guessing i'm setting up my Master Calendar wrong.</P><P></P><P>I have attached an limited example. where both dates and the sales amount are shown.&nbsp; but since the invoice date and the order aren't always the same.&nbsp; I would love to have the pivot like it's shown. sales in all the monts, and the order intake in the same month.&nbsp; </P><P></P><P>I found this link <A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A>&nbsp;&nbsp; and I have tried implementing it.. but i must be missing and important point.&nbsp; </P></BODY></HTML> Mon, 27 Mar 2017 20:17:08 GMT https://community.qlik.com/t5/QlikView/Calendar-for-two-dates/m-p/1289271#M619536 Anonymous 2017-03-27T20:17:08Z Re: Calendar for two dates https://community.qlik.com/t5/QlikView/Calendar-for-two-dates/m-p/1289272#M619537 <HTML><HEAD></HEAD><BODY><P>I believe you need to use canonical dates for your requirement</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Mon, 27 Mar 2017 20:55:36 GMT https://community.qlik.com/t5/QlikView/Calendar-for-two-dates/m-p/1289272#M619537 aarkay29 2017-03-27T20:55:36Z Re: Calendar for two dates https://community.qlik.com/t5/QlikView/Calendar-for-two-dates/m-p/1289273#M619538 <HTML><HEAD></HEAD><BODY><P>It looks exactly like how the idea in my head on how to solve it. I just didn't have enough imagination to create the datebrigde.&nbsp; Thanks for the tip.</P></BODY></HTML> Tue, 28 Mar 2017 06:54:23 GMT https://community.qlik.com/t5/QlikView/Calendar-for-two-dates/m-p/1289273#M619538 Anonymous 2017-03-28T06:54:23Z