Issue with Rangesum in Qlik Sense

cathy256 — Mon, 22 Oct 2018 15:16:27 GMT

Hello, need help with range sum in qlik sense. I have a chart like below, the highlighted yellow is then used in the table below it.

The second chart now gives an amortization view of the first, using EOM_MOS and YearMonth(201801, 201802...) like below. The first month use the value of the adjusted

the above were done in qlik. Expression used in the second chart is :

RangeSum(After(Sum(ADJ_ALLOC_TP)/EOM_MOS, 1, RowNo()))

I tried doing this in Qlik Sense and no luck. Need help pls. Here is what i see in qlik sense:

and this is using the pivot table extension

topic Issue with Rangesum in Qlik Sense in App Development

Issue with Rangesum in Qlik Sense