Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vkish16161
Creator III
Creator III

Rangesum behaving weirdly?

All,

Here's a screenshot of Executive Dashboard app available in QlikSense Desktop.


Rangesum is giving wrong value.


stalwar1

1 Solution

Accepted Solutions
swuehl
MVP
MVP

That's probably because you are using multiple dimensions, use the TOTAL qualifer:

Above ‒ QlikView

edit: or change the sort order priority

View solution in original post

4 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

You posted in "QlikView App Development". Maybe you want to move your question to a Qlik Sense forum?

Follow the steps listed here: QlikCommunity Tip: How to move your discussion thread

sunny_talwar

May be try this

RangeSum(Above(TOTAL Sum([Sales Amount]), 0, RowNo(TOTAL)))

Or this

Aggr(RangeSum(Above(Sum([Sales Amount]), 0, RowNo())), Month, (OrderDate, (NUMERIC)))

swuehl
MVP
MVP

That's probably because you are using multiple dimensions, use the TOTAL qualifer:

Above ‒ QlikView

edit: or change the sort order priority

vkish16161
Creator III
Creator III
Author

Wow.. didn't know that.

So the gist is:

If the table has more than 1 dimension we have to use TOTAL?

Thanks Stefan