topic Re: Cumulative Sum in App Development https://community.qlik.com/t5/App-Development/Cumulative-Sum/m-p/2143610#M93055 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/243706">@americanetsMD</a>&nbsp; You can use the below expression to get the desired output.</P> <P>Rangesum(Above(total Sum(value),0,RowNo(Total)))</P> <P>if this resolves your issue, please like and accept it as a solution.</P> Sun, 03 Dec 2023 04:40:19 GMT sidhiq91 2023-12-03T04:40:19Z Cumulative Sum https://community.qlik.com/t5/App-Development/Cumulative-Sum/m-p/2135385#M92276 <P>Hi everyone,</P> <P>Consider the following table:</P> <P>Spalte1Spalte2Spalte3Spalte4Spalte5Spalte7</P> <TABLE width="693"> <TBODY> <TR> <TD style="font-weight: 400;">ID</TD> <TD style="font-weight: 400;">CheckNr</TD> <TD style="font-weight: 400;">Year</TD> <TD style="font-weight: 400;">Period</TD> <TD style="font-weight: 400;">Sum(value)</TD> <TD style="font-weight: 400;">Cumulative EXPECTED</TD> </TR> <TR> <TD style="font-weight: 400;">&nbsp;</TD> <TD style="font-weight: 400;">&nbsp;</TD> <TD style="font-weight: 400;">&nbsp;</TD> <TD style="font-weight: 400;">&nbsp;</TD> <TD style="font-weight: 400;">&nbsp;</TD> <TD style="font-weight: 400;">&nbsp;</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002295481</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">01.2022</TD> <TD style="font-weight: 400;">39.531,00</TD> <TD style="font-weight: 400;">39.531,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">01.2022</TD> <TD style="font-weight: 400;">0,00</TD> <TD style="font-weight: 400;">39.531,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002295481</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">02.2022</TD> <TD style="font-weight: 400;">17.729,00</TD> <TD style="font-weight: 400;">57.260,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">03.2022</TD> <TD style="font-weight: 400;">14.910,00</TD> <TD style="font-weight: 400;">72.170,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002280650</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">04.2022</TD> <TD style="font-weight: 400;">38.224,00</TD> <TD style="font-weight: 400;">110.394,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002280650</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">05.2022</TD> <TD style="font-weight: 400;">22.042,00</TD> <TD style="font-weight: 400;">132.436,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002280650</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">06.2022</TD> <TD style="font-weight: 400;">-7.395,00</TD> <TD style="font-weight: 400;">125.041,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002295481</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">07.2022</TD> <TD style="font-weight: 400;">-18.807,00</TD> <TD style="font-weight: 400;">106.234,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">08.2022</TD> <TD style="font-weight: 400;">33.148,00</TD> <TD style="font-weight: 400;">139.382,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">09.2022</TD> <TD style="font-weight: 400;">-18.827,00</TD> <TD style="font-weight: 400;">120.555,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002124331</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">10.2022</TD> <TD style="font-weight: 400;">11.340,00</TD> <TD style="font-weight: 400;">131.895,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002223674</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">11.2022</TD> <TD style="font-weight: 400;">-9.730,00</TD> <TD style="font-weight: 400;">122.165,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002305918</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">12.2022</TD> <TD style="font-weight: 400;">-7.425,00</TD> <TD style="font-weight: 400;">114.740,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002124331</TD> <TD style="font-weight: 400;">2022</TD> <TD style="font-weight: 400;">12.2022</TD> <TD style="font-weight: 400;">-25.964,00</TD> <TD style="font-weight: 400;">88.776,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002124251</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">02.2023</TD> <TD style="font-weight: 400;">2.023,00</TD> <TD style="font-weight: 400;">90.799,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">03.2023</TD> <TD style="font-weight: 400;">86.068,00</TD> <TD style="font-weight: 400;">176.867,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">04.2023</TD> <TD style="font-weight: 400;">-136.292,00</TD> <TD style="font-weight: 400;">40.575,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002351693</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">05.2023</TD> <TD style="font-weight: 400;">3.207,00</TD> <TD style="font-weight: 400;">43.782,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">06.2023</TD> <TD style="font-weight: 400;">102.385,00</TD> <TD style="font-weight: 400;">146.167,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">07.2023</TD> <TD style="font-weight: 400;">-105.491,00</TD> <TD style="font-weight: 400;">40.676,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">keine Zuordnung</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">08.2023</TD> <TD style="font-weight: 400;">88.776,00</TD> <TD style="font-weight: 400;">129.452,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002124331</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">08.2023</TD> <TD style="font-weight: 400;">14.624,00</TD> <TD style="font-weight: 400;">144.076,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002223674</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">08.2023</TD> <TD style="font-weight: 400;">9.730,00</TD> <TD style="font-weight: 400;">153.806,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002305918</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">08.2023</TD> <TD style="font-weight: 400;">7.425,00</TD> <TD style="font-weight: 400;">161.231,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002280650</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">08.2023</TD> <TD style="font-weight: 400;">-22.965,00</TD> <TD style="font-weight: 400;">138.266,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002131001</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">08.2023</TD> <TD style="font-weight: 400;">-29.231,00</TD> <TD style="font-weight: 400;">109.035,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002295481</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">08.2023</TD> <TD style="font-weight: 400;">-38.453,00</TD> <TD style="font-weight: 400;">70.582,00</TD> </TR> <TR> <TD style="font-weight: 400;">3002</TD> <TD style="font-weight: 400;">3002280650</TD> <TD style="font-weight: 400;">2023</TD> <TD style="font-weight: 400;">09.2023</TD> <TD style="font-weight: 400;">19.170,00</TD> <TD style="font-weight: 400;">89.752,00</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I have a small problem on getting the right cumulative result(Cumulative EXPECTED) in the table.&nbsp; The Cumulative Result must be calculated no matter the year&nbsp; change.&nbsp;</P> <P>The Column&nbsp;(Cumulative EXPECTED) will be used in a pivot table, if this makes it somehow easier.</P> <P>Can anyone please help me with this. I am sure it has&nbsp; to be easy but i just can't get to that logic. <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P> Tue, 07 Nov 2023 13:03:16 GMT https://community.qlik.com/t5/App-Development/Cumulative-Sum/m-p/2135385#M92276 americanetsMD 2023-11-07T13:03:16Z Re: Cumulative Sum https://community.qlik.com/t5/App-Development/Cumulative-Sum/m-p/2143610#M93055 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/243706">@americanetsMD</a>&nbsp; You can use the below expression to get the desired output.</P> <P>Rangesum(Above(total Sum(value),0,RowNo(Total)))</P> <P>if this resolves your issue, please like and accept it as a solution.</P> Sun, 03 Dec 2023 04:40:19 GMT https://community.qlik.com/t5/App-Development/Cumulative-Sum/m-p/2143610#M93055 sidhiq91 2023-12-03T04:40:19Z Re: Cumulative Sum https://community.qlik.com/t5/App-Development/Cumulative-Sum/m-p/2144867#M93158 <P>Hello Sidhiq91,</P> <P>sorry for late answer. I have tried your expression and it work marvelous. Thank you.</P> Wed, 06 Dec 2023 14:38:58 GMT https://community.qlik.com/t5/App-Development/Cumulative-Sum/m-p/2144867#M93158 americanetsMD 2023-12-06T14:38:58Z