topic MTD Calculation in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/MTD-Calculation/m-p/751815#M1341 <HTML><HEAD></HEAD><BODY><P>how to calculate the MTD values .If i select the January mean it show the January sales values after that i select the FEB mean it show the FEB sales Values only BUT i want the addition of all previous month sales value&nbsp; .</P><P>Eg:</P><P>I select the May month sales mean I want Jan,Feb,March,April And May Months sales Vales.</P></BODY></HTML> Sat, 15 Nov 2014 06:59:53 GMT stephenedberkg 2014-11-15T06:59:53Z MTD Calculation https://community.qlik.com/t5/Qlik-Learning-Discussions/MTD-Calculation/m-p/751815#M1341 <HTML><HEAD></HEAD><BODY><P>how to calculate the MTD values .If i select the January mean it show the January sales values after that i select the FEB mean it show the FEB sales Values only BUT i want the addition of all previous month sales value&nbsp; .</P><P>Eg:</P><P>I select the May month sales mean I want Jan,Feb,March,April And May Months sales Vales.</P></BODY></HTML> Sat, 15 Nov 2014 06:59:53 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/MTD-Calculation/m-p/751815#M1341 stephenedberkg 2014-11-15T06:59:53Z Re: MTD Calculation https://community.qlik.com/t5/Qlik-Learning-Discussions/MTD-Calculation/m-p/751816#M1342 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In your expression try this expression</P><P></P><P></P><P></P><P></P><P>=Sum({$&lt;Month = {'&gt;$(=Min(Month))) &lt;=$(=Max(Month))'}, Year = {'$(=Max(Year))'}&gt;}&nbsp; Metrics )</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Sat, 15 Nov 2014 07:17:31 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/MTD-Calculation/m-p/751816#M1342 its_anandrjs 2014-11-15T07:17:31Z Re: MTD Calculation https://community.qlik.com/t5/Qlik-Learning-Discussions/MTD-Calculation/m-p/751817#M1343 <HTML><HEAD></HEAD><BODY><P>Thank you for reply <SPAN class="font-color-meta" style="padding: 0 0 5px; font-size: 1.2em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #e6e6e6;"><SPAN class="replyToName" style="font-weight: inherit; font-style: inherit; font-family: inherit;">Anand Chouhan</SPAN></SPAN></P></BODY></HTML> Sat, 15 Nov 2014 07:18:40 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/MTD-Calculation/m-p/751817#M1343 stephenedberkg 2014-11-15T07:18:40Z