topic Cumulative sum went wrong in App Development https://community.qlik.com/t5/App-Development/Cumulative-sum-went-wrong/m-p/1408531#M32998 <HTML><HEAD></HEAD><BODY><P>Hi good day to every one. im trying to create a Balance Sheet-&gt;Asset&nbsp; visualization where in it can be view by branch per month. so i use this formula.</P><P></P><P>rangesum( above( Sum({&lt;GLHeader= {1}&gt;} GLTOTAL ),0,rowno())) everything seems fine</P><P><IMG alt="Rangesum went wrong.JPG" class="jive-image image-1" src="/legacyfs/online/187050_Rangesum went wrong.JPG" style="height: auto;" /></P><P></P><P>but when i add another dimension for the branch... the data went wrong,</P><P><IMG alt="Rangesum went wrong part 2.JPG" class="jive-image image-2" src="/legacyfs/online/187051_Rangesum went wrong part 2.JPG" style="height: auto;" /></P><P></P><P>it and i dont know why i happens. can someone help me to correct my computation and visualization. and i am new in Qlik Sense. </P><P></P><P>Thanks</P></BODY></HTML> Wed, 22 Dec 2021 20:40:09 GMT raceberos 2021-12-22T20:40:09Z Cumulative sum went wrong https://community.qlik.com/t5/App-Development/Cumulative-sum-went-wrong/m-p/1408531#M32998 <HTML><HEAD></HEAD><BODY><P>Hi good day to every one. im trying to create a Balance Sheet-&gt;Asset&nbsp; visualization where in it can be view by branch per month. so i use this formula.</P><P></P><P>rangesum( above( Sum({&lt;GLHeader= {1}&gt;} GLTOTAL ),0,rowno())) everything seems fine</P><P><IMG alt="Rangesum went wrong.JPG" class="jive-image image-1" src="/legacyfs/online/187050_Rangesum went wrong.JPG" style="height: auto;" /></P><P></P><P>but when i add another dimension for the branch... the data went wrong,</P><P><IMG alt="Rangesum went wrong part 2.JPG" class="jive-image image-2" src="/legacyfs/online/187051_Rangesum went wrong part 2.JPG" style="height: auto;" /></P><P></P><P>it and i dont know why i happens. can someone help me to correct my computation and visualization. and i am new in Qlik Sense. </P><P></P><P>Thanks</P></BODY></HTML> Wed, 22 Dec 2021 20:40:09 GMT https://community.qlik.com/t5/App-Development/Cumulative-sum-went-wrong/m-p/1408531#M32998 raceberos 2021-12-22T20:40:09Z Re: Cumulative sum went wrong https://community.qlik.com/t5/App-Development/Cumulative-sum-went-wrong/m-p/1408532#M32999 <HTML><HEAD></HEAD><BODY><P>Check here:</P><P><A href="https://community.qlik.com/thread/285174">rangesum with 2 dimensions</A></P></BODY></HTML> Fri, 15 Dec 2017 12:36:14 GMT https://community.qlik.com/t5/App-Development/Cumulative-sum-went-wrong/m-p/1408532#M32999 sunny_talwar 2017-12-15T12:36:14Z