Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
cathy256
Contributor
Contributor

Issue with Rangesum in Qlik Sense

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

0 Replies