Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rheacock
Contributor II
Contributor II

RangeSum not working in a table

I've been struggling with RangeSum.  I have a simple sorted table that I want to accumulate the values for.  I'm using:

RangeSum field.PNG

where PLAN is the column to accumulate.  This is what I get:

RangeSum.PNG

It dosn't seem to want to pick up any previous values.  Any ideas?

Thanks!

1 Solution

Accepted Solutions
sunny_talwar

Do you have more than one dimension? May be this

RangeSum(Above(TOTAL Sum(PLAN), 0, RowNo(TOTAL)))

View solution in original post

3 Replies
Carlos_Reyes
Partner - Specialist
Partner - Specialist

It's weird, I can't tell what's the error in you case.

Review the enclosed file. It works just fine.

sunny_talwar

Do you have more than one dimension? May be this

RangeSum(Above(TOTAL Sum(PLAN), 0, RowNo(TOTAL)))

rheacock
Contributor II
Contributor II
Author

this worked.  Not sure why, but it did!  Thanks!