topic Re: Link Two Dates Together in QlikView https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767343#M1039288 <HTML><HEAD></HEAD><BODY><P>You might wanna look at Canonical Date :</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Fri, 19 Dec 2014 14:29:34 GMT jpenuliar 2014-12-19T14:29:34Z Link Two Dates Together https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767341#M1039286 <HTML><HEAD></HEAD><BODY><P><IMG alt="Snapshot.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73906_Snapshot.png" style="width: 620px; height: 388px;" /></P><P>I know there is probably a simple answer to this question, but this is my first time having this issue and I can't find a discussion that makes sense to me on the topic. In this table the Quantity(LP_Gal) and Charge(Other_Costs) are in a table that uses OApply_dt and Pigs Weaned(fsPigsProduced) is in a table that uses fsFiscalYear &amp; fsFiscalPeriod. Is there a way to link these two dates together and only have to select the Month and Year one time to effect both sides of table. Any help you can offer will be greatly appreciated.</P></BODY></HTML> Fri, 19 Dec 2014 14:23:41 GMT https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767341#M1039286 Anonymous 2014-12-19T14:23:41Z Re: Link Two Dates Together https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767342#M1039287 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please follow this link,<A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P><P></P><P>regards,</P><P>Amay</P></BODY></HTML> Fri, 19 Dec 2014 14:27:46 GMT https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767342#M1039287 2014-12-19T14:27:46Z Re: Link Two Dates Together https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767343#M1039288 <HTML><HEAD></HEAD><BODY><P>You might wanna look at Canonical Date :</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Fri, 19 Dec 2014 14:29:34 GMT https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767343#M1039288 jpenuliar 2014-12-19T14:29:34Z Re: Link Two Dates Together https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767344#M1039289 <HTML><HEAD></HEAD><BODY><P>or Common Calendar by <A href="https://community.qlik.com/qlik-users/2286">rwunderlich</A></P><P><A href="https://community.qlik.com/docs/DOC-5834">Linking to two or more dates</A></P></BODY></HTML> Fri, 19 Dec 2014 14:31:43 GMT https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767344#M1039289 jpenuliar 2014-12-19T14:31:43Z Re: Link Two Dates Together https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767345#M1039290 <HTML><HEAD></HEAD><BODY><P>Does anyone have any examples or would you be able to show me on the qvw that I attached?</P></BODY></HTML> Fri, 19 Dec 2014 15:09:25 GMT https://community.qlik.com/t5/QlikView/Link-Two-Dates-Together/m-p/767345#M1039290 Anonymous 2014-12-19T15:09:25Z