topic Re: MTD calculate in QlikView https://community.qlik.com/t5/QlikView/MTD-calculate/m-p/810442#M286104 <HTML><HEAD></HEAD><BODY><P>You have to write</P><P></P><P>=Sum({&lt;[Util Daterep]= {'&gt;=$(=Max((MonthStart([Util Daterep])))) &lt;=$(=Max([Util Daterep]))'}&gt;} [Amount Verified])</P><P></P><P>Some Bracket and comma mistake</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 10 Dec 2014 21:41:39 GMT its_anandrjs 2014-12-10T21:41:39Z MTD calculate https://community.qlik.com/t5/QlikView/MTD-calculate/m-p/810441#M286103 <HTML><HEAD></HEAD><BODY><P>What error in the expression it is MTD calculation.</P><P></P><P>=Sum( {&lt;[Util Daterep] = { ' &gt;=$(=Max((MonthStart([Util Daterep])))) &lt;=$(Max([Util Daterep]) '&nbsp; }&gt;} [Amount Verified])</P><P></P><P>Jay</P></BODY></HTML> Wed, 10 Dec 2014 21:27:02 GMT https://community.qlik.com/t5/QlikView/MTD-calculate/m-p/810441#M286103 2014-12-10T21:27:02Z Re: MTD calculate https://community.qlik.com/t5/QlikView/MTD-calculate/m-p/810442#M286104 <HTML><HEAD></HEAD><BODY><P>You have to write</P><P></P><P>=Sum({&lt;[Util Daterep]= {'&gt;=$(=Max((MonthStart([Util Daterep])))) &lt;=$(=Max([Util Daterep]))'}&gt;} [Amount Verified])</P><P></P><P>Some Bracket and comma mistake</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 10 Dec 2014 21:41:39 GMT https://community.qlik.com/t5/QlikView/MTD-calculate/m-p/810442#M286104 its_anandrjs 2014-12-10T21:41:39Z Re: MTD calculate https://community.qlik.com/t5/QlikView/MTD-calculate/m-p/810443#M286105 <HTML><HEAD></HEAD><BODY><P>Small mistakes any other way of same problem.</P><P></P><P>Jay</P></BODY></HTML> Thu, 11 Dec 2014 18:17:13 GMT https://community.qlik.com/t5/QlikView/MTD-calculate/m-p/810443#M286105 2014-12-11T18:17:13Z