Discussion Board for collaboration related to QlikView App Development.
Here's a screenshot of Executive Dashboard app available in QlikSense Desktop.
Rangesum is giving wrong value.
Go to Solution.
That's probably because you are using multiple dimensions, use the TOTAL qualifer:
Above ‒ QlikView
edit: or change the sort order priority
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
May be try this
RangeSum(Above(TOTAL Sum([Sales Amount]), 0, RowNo(TOTAL)))
Aggr(RangeSum(Above(Sum([Sales Amount]), 0, RowNo())), Month, (OrderDate, (NUMERIC)))
Wow.. didn't know that.
So the gist is:
If the table has more than 1 dimension we have to use TOTAL?