topic RangeSum Question in QlikView https://community.qlik.com/t5/QlikView/RangeSum-Question/m-p/595613#M1096797 <HTML><HEAD></HEAD><BODY><P>I have an issue that i am trying to resolve using rangesum. It works fine when first initialized, however when i update the information the way i would like (sorting),&nbsp; i would like the rangesum to accumulate using the new sorted numbers.</P><P></P><P>See example attached that someone had made in another topic. Instead of "e" showing the rangesum of 175 as the total from original load, i would like it to now show 42 , g would show 84 instead of 217 when I sort from highest to lowest value.</P><P></P><P>I am trying to rank sales of items based on a cumulative amount, as i would like to rank anything say below 75% of an amount as A, then between x and y, as B, and balance as C. I am stumped in moving forward. If needed, i can attach a sample of my actual application i am working on.</P><P></P><P>Thanks,</P><P></P><P>Andrew Kersys</P></BODY></HTML> Fri, 18 Apr 2014 21:06:07 GMT 2014-04-18T21:06:07Z RangeSum Question https://community.qlik.com/t5/QlikView/RangeSum-Question/m-p/595613#M1096797 <HTML><HEAD></HEAD><BODY><P>I have an issue that i am trying to resolve using rangesum. It works fine when first initialized, however when i update the information the way i would like (sorting),&nbsp; i would like the rangesum to accumulate using the new sorted numbers.</P><P></P><P>See example attached that someone had made in another topic. Instead of "e" showing the rangesum of 175 as the total from original load, i would like it to now show 42 , g would show 84 instead of 217 when I sort from highest to lowest value.</P><P></P><P>I am trying to rank sales of items based on a cumulative amount, as i would like to rank anything say below 75% of an amount as A, then between x and y, as B, and balance as C. I am stumped in moving forward. If needed, i can attach a sample of my actual application i am working on.</P><P></P><P>Thanks,</P><P></P><P>Andrew Kersys</P></BODY></HTML> Fri, 18 Apr 2014 21:06:07 GMT https://community.qlik.com/t5/QlikView/RangeSum-Question/m-p/595613#M1096797 2014-04-18T21:06:07Z