topic Re: How to Calculate the Cumulative Month sales in QlikView https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989059#M969998 <HTML><HEAD></HEAD><BODY><P>I try your expression, it works fine. Mang thanks. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Tue, 22 Sep 2015 03:16:09 GMT 2015-09-22T03:16:09Z How to Calculate the Cumulative Month sales https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989056#M969995 <HTML><HEAD></HEAD><BODY><P>Could you help to tell me how to write the express to Calculate the Cumulative Month sales?</P><P></P><P>For example:</P><P></P><P>The January sales amount is 100</P><P>The February sales amount is 200</P><P>The March sales amount is 300</P><P></P><P>The result:</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"><STRONG>Month </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">January </TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">February </TD><TD style="padding: 2px;">300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (100+200) January+February<TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></TD></TR><TR><TD style="padding: 2px;">March</TD><TD style="padding: 2px;">600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (100+200+300) January+February+March</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 21 Sep 2015 06:48:05 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989056#M969995 2015-09-21T06:48:05Z Re: How to Calculate the Cumulative Month sales https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989057#M969996 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I attach you an example with a simple table, I hope will help you.</P><P><IMG alt="Group1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/99560_Group1.JPG" style="height: 550px; width: 620px;" /></P><P>Regards.</P></BODY></HTML> Mon, 21 Sep 2015 14:47:58 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989057#M969996 Anonymous 2015-09-21T14:47:58Z Re: How to Calculate the Cumulative Month sales https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989058#M969997 <HTML><HEAD></HEAD><BODY><P>Or you can do this:</P><P></P><P><STRONG>=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))</STRONG></P></BODY></HTML> Mon, 21 Sep 2015 14:54:58 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989058#M969997 sunny_talwar 2015-09-21T14:54:58Z Re: How to Calculate the Cumulative Month sales https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989059#M969998 <HTML><HEAD></HEAD><BODY><P>I try your expression, it works fine. Mang thanks. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Tue, 22 Sep 2015 03:16:09 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989059#M969998 2015-09-22T03:16:09Z Re: How to Calculate the Cumulative Month sales https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989060#M969999 <HTML><HEAD></HEAD><BODY><P>Many thanks. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 22 Sep 2015 03:16:30 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989060#M969999 2015-09-22T03:16:30Z Re: How to Calculate the Cumulative Month sales https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989061#M970000 <HTML><HEAD></HEAD><BODY><P>Awesome, I am glad it worked.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 22 Sep 2015 03:21:49 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989061#M970000 sunny_talwar 2015-09-22T03:21:49Z Re: How to Calculate the Cumulative Month sales https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989062#M970001 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 22 Sep 2015 13:58:18 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-the-Cumulative-Month-sales/m-p/989062#M970001 Anonymous 2015-09-22T13:58:18Z