topic QVC_MTD Previous month in QlikView https://community.qlik.com/t5/QlikView/QVC-MTD-Previous-month/m-p/366707#M573775 <HTML><HEAD></HEAD><BODY><DIV><DIV>Hi </DIV></DIV><P></P><P>Am trying to compare previous month call count with the current month.i used fisical calender its working fine but i foundsome discrepancy. In aug 31days are there if i select sep am getting MTD previous month count till 30th aug only, also if i select feb it's counting till 28 or 29 days. Please suggest me how to overcome this issue.</P></BODY></HTML> Wed, 25 Jul 2012 09:42:58 GMT anithashivalingappa 2012-07-25T09:42:58Z QVC_MTD Previous month https://community.qlik.com/t5/QlikView/QVC-MTD-Previous-month/m-p/366707#M573775 <HTML><HEAD></HEAD><BODY><DIV><DIV>Hi </DIV></DIV><P></P><P>Am trying to compare previous month call count with the current month.i used fisical calender its working fine but i foundsome discrepancy. In aug 31days are there if i select sep am getting MTD previous month count till 30th aug only, also if i select feb it's counting till 28 or 29 days. Please suggest me how to overcome this issue.</P></BODY></HTML> Wed, 25 Jul 2012 09:42:58 GMT https://community.qlik.com/t5/QlikView/QVC-MTD-Previous-month/m-p/366707#M573775 anithashivalingappa 2012-07-25T09:42:58Z Re: QVC_MTD Previous month https://community.qlik.com/t5/QlikView/QVC-MTD-Previous-month/m-p/366708#M573776 <HTML><HEAD></HEAD><BODY><P>This is the nature of MTD.&nbsp; The question is - how do you want it to work?<BR />Case 1:<BR />Today is February 28, 2012.&nbsp; Previous MTD should include Jan 28.&nbsp; Is it correct?&nbsp; Why?<BR />Case 2:<BR />Today is February 29, 2012.&nbsp; Previous MTD should include Jan 29.&nbsp; Or should it be Jan 31?&nbsp; Why or why not?&nbsp; How can you tell which one is correct?&nbsp; They both can be correct, depending on what you're looking for.&nbsp; </P><P>Maybe you need a switch showing if you want the full or partial previous month, and use a conditional calculation.</P><P></P><P>Regards,<BR />Michael</P></BODY></HTML> Wed, 25 Jul 2012 10:33:36 GMT https://community.qlik.com/t5/QlikView/QVC-MTD-Previous-month/m-p/366708#M573776 Anonymous 2012-07-25T10:33:36Z