topic Re: cumulative sum in line graph Qlik Sense in App Development https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438674#M34689 <HTML><HEAD></HEAD><BODY><P>Im very thankfull!!</P><P></P><P>Nice weekend</P></BODY></HTML> Fri, 27 Oct 2017 12:24:00 GMT Anonymous 2017-10-27T12:24:00Z cumulative sum in line graph Qlik Sense https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438668#M34683 <HTML><HEAD></HEAD><BODY><P>Hello i have line graph that i want to make cumulative. My expression right now is.</P><P></P><P></P><P>IF((GETSELECTEDCOUNT(Jaar) OR GETSELECTEDCOUNT(Maand) OR GETSELECTEDCOUNT(Maandjaar) OR GETSELECTEDCOUNT(Kalenderdatum)) = 0, </P><P>&nbsp;&nbsp;&nbsp; SUM({$ &lt;`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"&lt;=$(=MAX(previous_period_flag_current_year))"}, Jaar = {"$(=MAX(Jaar))"}&nbsp; &gt;} Gerealiseerd) / 1000,</P><P>&nbsp;&nbsp;&nbsp; SUM({$ &lt;`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"&lt;=$(=MAX(periode_flag_current_year))"}, Jaar = {"$(=MAX(Jaar))"}&nbsp; &gt;} Gerealiseerd) / 1000</P><P>)</P><P></P><P>I know you need to a rangesum but can someone help me? Thanks already</P></BODY></HTML> Thu, 26 Oct 2017 07:05:15 GMT https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438668#M34683 Anonymous 2017-10-26T07:05:15Z Re: cumulative sum in line graph Qlik Sense https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438669#M34684 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG style="color: #ff0000;">RangeSum(Above(</STRONG></P><P><STRONG>IF((GETSELECTEDCOUNT(Jaar) OR GETSELECTEDCOUNT(Maand) OR GETSELECTEDCOUNT(Maandjaar) OR GETSELECTEDCOUNT(Kalenderdatum)) = 0,</STRONG></P><P><STRONG>SUM({$ &lt;`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"&lt;=$(=MAX(previous_period_flag_current_year))"}, Jaar = {"$(=MAX(Jaar))"}&nbsp; &gt;} Gerealiseerd) / 1000,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; SUM({$ &lt;`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"&lt;=$(=MAX(periode_flag_current_year))"}, Jaar = {"$(=MAX(Jaar))"}&nbsp; &gt;} Gerealiseerd) / 1000</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>)<SPAN style="color: #ff0000;">, 0, RowNo()))</SPAN></STRONG></P></BODY></HTML> Thu, 26 Oct 2017 12:07:51 GMT https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438669#M34684 sunny_talwar 2017-10-26T12:07:51Z Re: cumulative sum in line graph Qlik Sense https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438670#M34685 <HTML><HEAD></HEAD><BODY><P>This doenst work get line from 0 back.</P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">can someone else help?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks already<BR /></SPAN></P></BODY></HTML> Fri, 27 Oct 2017 11:00:52 GMT https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438670#M34685 Anonymous 2017-10-27T11:00:52Z Re: cumulative sum in line graph Qlik Sense https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438671#M34686 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample?</P></BODY></HTML> Fri, 27 Oct 2017 11:09:34 GMT https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438671#M34686 sunny_talwar 2017-10-27T11:09:34Z Re: cumulative sum in line graph Qlik Sense https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438672#M34687 <HTML><HEAD></HEAD><BODY><P>Attached the app</P></BODY></HTML> Fri, 27 Oct 2017 12:07:42 GMT https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438672#M34687 Anonymous 2017-10-27T12:07:42Z Re: cumulative sum in line graph Qlik Sense https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438673#M34688 <HTML><HEAD></HEAD><BODY><P>Seems to be accumulating?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181276_Capture.PNG" style="height: 728px; width: 620px;" /></P></BODY></HTML> Fri, 27 Oct 2017 12:22:47 GMT https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438673#M34688 sunny_talwar 2017-10-27T12:22:47Z Re: cumulative sum in line graph Qlik Sense https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438674#M34689 <HTML><HEAD></HEAD><BODY><P>Im very thankfull!!</P><P></P><P>Nice weekend</P></BODY></HTML> Fri, 27 Oct 2017 12:24:00 GMT https://community.qlik.com/t5/App-Development/cumulative-sum-in-line-graph-Qlik-Sense/m-p/1438674#M34689 Anonymous 2017-10-27T12:24:00Z