topic Re: How to calculate MTD in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-MTD/m-p/1181321#M883389 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 27 Sep 2016 04:06:32 GMT anindya_manna 2016-09-27T04:06:32Z How to calculate MTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD/m-p/1181319#M883385 <HTML><HEAD></HEAD><BODY><P>I want to display MTD sales based on shipdate DD-MM-YYYY format.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD/m-p/1181319#M883385 anindya_manna 2020-11-25T16:16:04Z Re: How to calculate MTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD/m-p/1181320#M883387 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Sum(<SPAN style="color: #ff0000;">{&lt;shipdate = {"$(='&gt;=' &amp; Date(MonthStart(Max(shipdate)), '<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DD-MM-YYYY'</SPAN>) &amp; '&lt;=' &amp; <SPAN style="font-size: 13.3333px;">Date(Max(shipdate), '</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DD-MM-YYYY'</SPAN><SPAN style="font-size: 13.3333px;">)</SPAN>)"}&gt;}</SPAN>Measure)</STRONG></P></BODY></HTML> Mon, 26 Sep 2016 16:34:58 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD/m-p/1181320#M883387 sunny_talwar 2016-09-26T16:34:58Z Re: How to calculate MTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD/m-p/1181321#M883389 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 27 Sep 2016 04:06:32 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD/m-p/1181321#M883389 anindya_manna 2016-09-27T04:06:32Z