Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rheacock
New Contributor

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
MVP
MVP

Re: RangeSum not working in a table

Do you have more than one dimension? May be this

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

3 Replies
carlos_reyes_qv
Valued Contributor

Re: RangeSum not working in a table

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

Review the enclosed file. It works just fine.

MVP
MVP

Re: RangeSum not working in a table

Do you have more than one dimension? May be this

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

rheacock
New Contributor

Re: RangeSum not working in a table

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