Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dmelillo
Creator III
Creator III

Full Accumulation in QlikSense

Goal is to sum subscription dollars over time to see how individual companies are growing within our ecosystem over time.

I am using QlikSense. I know there is not a Full Accumulation button in QlikSense so I have been using the following expression.

= rangesum(above(Sum({<[Opps.IsWon] = {'1'}>}[Opps.ARR_equivalent__c]),0,rowno()))

However it is not working as expected. If you see the graph below it is just summing the subscription amounts per subscription start date (x axis) ... Any help is appreciated!!!

QLIK06212017.PNG

1 Solution

Accepted Solutions
sunny_talwar

Do you have two dimensions in your chart? May be this

=RangeSum(Above(TOTAL Sum({<[Opps.IsWon] = {'1'}>}[Opps.ARR_equivalent__c]), 0, RowNo(TOTAL)))

View solution in original post

2 Replies
sunny_talwar

Do you have two dimensions in your chart? May be this

=RangeSum(Above(TOTAL Sum({<[Opps.IsWon] = {'1'}>}[Opps.ARR_equivalent__c]), 0, RowNo(TOTAL)))

View solution in original post

dmelillo
Creator III
Creator III
Author

Yes I do, 1 dimension is SUBSCRIPTION START DATE on X axis, 2nd dimension is ACCOUNT NAME ...

This worked. Thank you!