topic SUM for each month in App Development https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856110#M70656 <P>Hi,</P> <P>I have an qliksense table as below.</P> <P>I want the new field T<STRONG>otal Month</STRONG> to be calculated as below. Is it possible using any expression? Thanks</P> <P>MonthDate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Month</P> <P>April&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000</P> <P>April&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000</P> <P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4500</P> <P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4500</P> Fri, 05 Nov 2021 14:48:49 GMT jpjust 2021-11-05T14:48:49Z SUM for each month https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856110#M70656 <P>Hi,</P> <P>I have an qliksense table as below.</P> <P>I want the new field T<STRONG>otal Month</STRONG> to be calculated as below. Is it possible using any expression? Thanks</P> <P>MonthDate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Month</P> <P>April&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000</P> <P>April&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000</P> <P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4500</P> <P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4500</P> Fri, 05 Nov 2021 14:48:49 GMT https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856110#M70656 jpjust 2021-11-05T14:48:49Z Re: SUM for each month https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856129#M70657 <P>Just use Sum(Total&lt;MonthDate&gt; Amount) for your Total Month expression</P> Fri, 05 Nov 2021 15:11:49 GMT https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856129#M70657 eike_s 2021-11-05T15:11:49Z Re: SUM for each month https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856131#M70658 <P>try with the TOTAL&nbsp;</P> <P>Sum(TOTAL &lt;MonthDate&gt; Amount)</P> <P>You can read more on TOTAL&nbsp;</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Aggregation-Scope/ba-p/1467321" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Aggregation-Scope/ba-p/1467321</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990</A></P> <P>&nbsp;</P> Fri, 05 Nov 2021 15:16:27 GMT https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856131#M70658 maxgro 2021-11-05T15:16:27Z Re: SUM for each month https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856134#M70659 <P>Thanks.</P> <P>It presents me with an wrong value.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jpjust_0-1636125596362.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66069i0ACB2341D2C2A700/image-size/medium?v=v2&amp;px=400" role="button" title="jpjust_0-1636125596362.png" alt="jpjust_0-1636125596362.png" /></span></P> <P>&nbsp;</P> Fri, 05 Nov 2021 15:20:14 GMT https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856134#M70659 jpjust 2021-11-05T15:20:14Z Re: SUM for each month https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856160#M70661 <P>Sorry, I validated the data wrongly. Actually it worked.</P> <P>Thanks much for your help.</P> Fri, 05 Nov 2021 16:06:54 GMT https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856160#M70661 jpjust 2021-11-05T16:06:54Z Re: SUM for each month https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856161#M70662 <P>Hi Max, Thanks for the resources, I will go over it.</P> Fri, 05 Nov 2021 16:07:36 GMT https://community.qlik.com/t5/App-Development/SUM-for-each-month/m-p/1856161#M70662 jpjust 2021-11-05T16:07:36Z