Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!