topic Re: Master Calendar in QlikView https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913680#M529469 <HTML><HEAD></HEAD><BODY><P>Please see the attached</P></BODY></HTML> Thu, 06 Aug 2015 10:34:39 GMT Kushal_Chawda 2015-08-06T10:34:39Z Master Calendar https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913679#M529468 <HTML><HEAD></HEAD><BODY><P>Hi.. </P><P></P><P>I have to create a master calendar for the&nbsp; below sample data</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="233"><TBODY><TR><TD height="20" width="64">MAR</TD><TD width="88">Created Date</TD><TD width="81">Closed Date</TD></TR><TR><TD height="20">ABC1</TD><TD align="right" class="xl63">6/1/2015</TD><TD align="right" class="xl63">6/1/2015</TD></TR><TR><TD height="20">ABC2</TD><TD align="right" class="xl63">6/2/2015</TD><TD align="right" class="xl63">6/2/2015</TD></TR><TR><TD height="20">ABC3</TD><TD align="right" class="xl63">6/3/2015</TD><TD align="right" class="xl63">6/3/2015</TD></TR><TR><TD height="20">ABC4</TD><TD align="right" class="xl63">5/4/2015</TD><TD align="right" class="xl63"><P>6/3/2015</P></TD></TR></TBODY></TABLE><P>The selection made on the date should work both for CreatedDate and Closed Date</P><P></P><P></P><P>Thanks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Thu, 06 Aug 2015 10:13:18 GMT https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913679#M529468 2015-08-06T10:13:18Z Re: Master Calendar https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913680#M529469 <HTML><HEAD></HEAD><BODY><P>Please see the attached</P></BODY></HTML> Thu, 06 Aug 2015 10:34:39 GMT https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913680#M529469 Kushal_Chawda 2015-08-06T10:34:39Z Re: Master Calendar https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913681#M529470 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this link</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 06 Aug 2015 10:36:31 GMT https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913681#M529470 jagan 2015-08-06T10:36:31Z Re: Master Calendar https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913682#M529471 <HTML><HEAD></HEAD><BODY><P>Hi Senthil,</P><P></P><P>you need to use the function Intervalmatch().</P><P></P><P>Here's a solution of what you need.</P><P></P><P>Regards, M.</P></BODY></HTML> Thu, 06 Aug 2015 10:40:35 GMT https://community.qlik.com/t5/QlikView/Master-Calendar/m-p/913682#M529471 marcel_olmo 2015-08-06T10:40:35Z