topic Re: Master Calander. in QlikView https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915154#M652110 <HTML><HEAD></HEAD><BODY><P>Seems like you were forcing QV to read Order_Date as <STRONG>MMDDYYYY </STRONG>(by using the Date#() function when in fact it was <STRONG>MM/DD/YYYY</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93994_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 26 Jul 2015 11:03:35 GMT sunny_talwar 2015-07-26T11:03:35Z Master Calander. https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915151#M652107 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could Any One create Master Calander for it. i tried it but after apply the calander my date field is empty.</P><P>is there any other way to create calander .</P><P></P><P>Thanks</P></BODY></HTML> Sun, 26 Jul 2015 06:50:58 GMT https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915151#M652107 2015-07-26T06:50:58Z Re: Master Calander. https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915152#M652108 <HTML><HEAD></HEAD><BODY><P>Looks like the format of Date is different in your excel file.</P><P>Please provide your excel file here.</P></BODY></HTML> Sun, 26 Jul 2015 08:33:55 GMT https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915152#M652108 MK_QSL 2015-07-26T08:33:55Z Re: Master Calander. https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915153#M652109 <HTML><HEAD></HEAD><BODY><P>Thanks Manish,</P><P>could u please see in new post i attached the excel file there.</P><P></P><P>Thanks</P></BODY></HTML> Sun, 26 Jul 2015 09:32:39 GMT https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915153#M652109 2015-07-26T09:32:39Z Re: Master Calander. https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915154#M652110 <HTML><HEAD></HEAD><BODY><P>Seems like you were forcing QV to read Order_Date as <STRONG>MMDDYYYY </STRONG>(by using the Date#() function when in fact it was <STRONG>MM/DD/YYYY</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93994_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 26 Jul 2015 11:03:35 GMT https://community.qlik.com/t5/QlikView/Master-Calander/m-p/915154#M652110 sunny_talwar 2015-07-26T11:03:35Z