Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cathy256
Contributor
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
Contributor
Contributor
Author

Any suggestion on this please?