topic Re: Rangesum behaving weirdly? in QlikView

Rangesum behaving weirdly?

vkish16161 — Fri, 13 Oct 2017 14:35:36 GMT

All,

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

Rangesum is giving wrong value.

stalwar1‌

Peter_Cammaert — Fri, 13 Oct 2017 14:39:50 GMT

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

sunny_talwar — Fri, 13 Oct 2017 14:39:50 GMT

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 — Fri, 13 Oct 2017 14:40:56 GMT

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

edit: or change the sort order priority

vkish16161 — Fri, 13 Oct 2017 14:51:28 GMT

Wow.. didn't know that.

So the gist is:

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

Thanks Stefan