Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

RangeSum Question

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),  i would like the rangesum to accumulate using the new sorted numbers.

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.

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.

Thanks,

Andrew Kersys

0 Replies