Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
cathy256
New Contributor

RangeSum not working same way in QlikSense

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.originalamort.PNG

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

amort.PNG

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:

amort Qlik Sense.PNG

and this is using the pivot table extension

1 Reply
cathy256
New Contributor

Re: RangeSum not working same way in QlikSense

Any suggestion on this please?