Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sekharapp
Contributor III
Contributor III

cumulative sum

How to do cumulative sum in qliksense (Interview question

)

1 Solution

Accepted Solutions
Mike_Dickson
Support
Support

Hello Sekharapp,

I was able to find the following within the Qlik Community:
RangeSum(Above(TOTAL Sum(Qty), 1, RowNo(TOTAL)))

https://community.qlik.com/t5/QlikView-App-Dev/Cumulative-SUM-in-Qlik-Expression/td-p/1399466

RangeSum(Above(TOTAL Sum(Qty), 0, RowNo(TOTAL)))

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-calculate-cumulative-sum-without-impacting-so...

I hope this helps!

 

 

Sr. Technical Support Engineer with Qlik Support
Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
Mike_Dickson
Support
Support

Hello Sekharapp,

I was able to find the following within the Qlik Community:
RangeSum(Above(TOTAL Sum(Qty), 1, RowNo(TOTAL)))

https://community.qlik.com/t5/QlikView-App-Dev/Cumulative-SUM-in-Qlik-Expression/td-p/1399466

RangeSum(Above(TOTAL Sum(Qty), 0, RowNo(TOTAL)))

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-calculate-cumulative-sum-without-impacting-so...

I hope this helps!

 

 

Sr. Technical Support Engineer with Qlik Support
Don't forget to mark a solution that worked for you!
Mike_Dickson
Support
Support

Also, please let us know if these formulas / links help with what you are trying to do by clicking on the box "Accept as Solution"

Sr. Technical Support Engineer with Qlik Support
Don't forget to mark a solution that worked for you!