topic Re: Common Calendar for Multiple dates in Multiple tables in QlikView https://community.qlik.com/t5/QlikView/Common-Calendar-for-Multiple-dates-in-Multiple-tables/m-p/1319470#M409085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be this help?</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A>‌</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 31 Jul 2017 14:18:32 GMT ahaahaaha 2017-07-31T14:18:32Z Common Calendar for Multiple dates in Multiple tables https://community.qlik.com/t5/QlikView/Common-Calendar-for-Multiple-dates-in-Multiple-tables/m-p/1319469#M409084 <HTML><HEAD></HEAD><BODY><P>Hello Friends.</P><P></P><P>I have one requirement&nbsp; in Qlikview for HR Data Set where I have multiple Date field in 2 different tables. (Requisition data &amp; Candidate Data)</P><P><SPAN style="font-size: 10pt;">Now I want to create a common calendar corresponding to both the tables. Somehow I tried concatenation statement against each date field but that is duplicating my data. Please help me with the solution of how to implement common calendar concept in this case. If possible through any QVW file. I am attaching the sample data sheet for same.</SPAN></P><P><SPAN style="font-size: 10pt;">Thanks in Advance.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Amit Sharma<BR /></SPAN></P></BODY></HTML> Mon, 31 Jul 2017 14:11:42 GMT https://community.qlik.com/t5/QlikView/Common-Calendar-for-Multiple-dates-in-Multiple-tables/m-p/1319469#M409084 2017-07-31T14:11:42Z Re: Common Calendar for Multiple dates in Multiple tables https://community.qlik.com/t5/QlikView/Common-Calendar-for-Multiple-dates-in-Multiple-tables/m-p/1319470#M409085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be this help?</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A>‌</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 31 Jul 2017 14:18:32 GMT https://community.qlik.com/t5/QlikView/Common-Calendar-for-Multiple-dates-in-Multiple-tables/m-p/1319470#M409085 ahaahaaha 2017-07-31T14:18:32Z