Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Re: Rangesum behaving weirdly?

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

Above ‒ QlikView

edit: or change the sort order priority

4 Replies

Re: Rangesum behaving weirdly?

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

Highlighted

Re: Rangesum behaving weirdly?

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

MVP
MVP

Re: Rangesum behaving weirdly?

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

Above ‒ QlikView

edit: or change the sort order priority

vkish16161
Contributor III

Re: Rangesum behaving weirdly?

Wow.. didn't know that.

So the gist is:

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

Thanks Stefan