Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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