topic How to calculate daily MTD volume? in App Development https://community.qlik.com/t5/App-Development/How-to-calculate-daily-MTD-volume/m-p/67691#M4521 <HTML><HEAD></HEAD><BODY><P>How would you calculate the daily MTD Volume as shown in the table below?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle">Date</TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle">Volume</TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle">Daily MTD</TH></TR><TR><TD style="padding: 2px; text-align: center;">02/01/2018</TD><TD style="padding: 2px; text-align: center;">100</TD><TD style="padding: 2px; text-align: center;">100</TD></TR><TR><TD style="text-align: center;">02/02/2018</TD><TD style="text-align: center;">50</TD><TD style="text-align: center;">150</TD></TR><TR><TD style="text-align: center;">02/03/2018</TD><TD style="text-align: center;">20</TD><TD style="text-align: center;">170</TD></TR><TR><TD style="text-align: center;">02/03/2018</TD><TD style="text-align: center;">10</TD><TD style="text-align: center;">180</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 07 Mar 2018 21:19:01 GMT ckchouk123 2018-03-07T21:19:01Z How to calculate daily MTD volume? https://community.qlik.com/t5/App-Development/How-to-calculate-daily-MTD-volume/m-p/67691#M4521 <HTML><HEAD></HEAD><BODY><P>How would you calculate the daily MTD Volume as shown in the table below?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle">Date</TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle">Volume</TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle">Daily MTD</TH></TR><TR><TD style="padding: 2px; text-align: center;">02/01/2018</TD><TD style="padding: 2px; text-align: center;">100</TD><TD style="padding: 2px; text-align: center;">100</TD></TR><TR><TD style="text-align: center;">02/02/2018</TD><TD style="text-align: center;">50</TD><TD style="text-align: center;">150</TD></TR><TR><TD style="text-align: center;">02/03/2018</TD><TD style="text-align: center;">20</TD><TD style="text-align: center;">170</TD></TR><TR><TD style="text-align: center;">02/03/2018</TD><TD style="text-align: center;">10</TD><TD style="text-align: center;">180</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 07 Mar 2018 21:19:01 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-daily-MTD-volume/m-p/67691#M4521 ckchouk123 2018-03-07T21:19:01Z Re: How to calculate daily MTD volume? https://community.qlik.com/t5/App-Development/How-to-calculate-daily-MTD-volume/m-p/67692#M4522 <HTML><HEAD></HEAD><BODY><P>Try this expression -</P><P>RangeSum(Above(Sum(Volume),0,Rowno()))</P></BODY></HTML> Thu, 08 Mar 2018 05:03:37 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-daily-MTD-volume/m-p/67692#M4522 Digvijay_Singh 2018-03-08T05:03:37Z