Rangesum behaving weirdly?

[vkish16161]

All,

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

Rangesum is giving wrong value.

stalwar1‌

[Peter_Cammaert]

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 · Accepted solution]

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

Above ‒ QlikView‌

edit: or change the sort order priority

[vkish16161]

Wow.. didn't know that.

So the gist is:

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

Thanks Stefan