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: 
cas-ictp
Contributor
Contributor

Cumulative sum

Hello,

I want to calculate the cumulative of VariableC in a new column. I have straight table (in diagram mode) with the variables:

  • VariableA = itemNo
  • VariableB = number of itemNo (calculated in load script)
  • VariableC = more specific number of itemNo (calculated in load script)

In the table (diagram mode) I sorted VariableC in descending order.

I have tried to calculate the cumulative values of variableC with the following formula :

RANGESUM(ABOVE(SUM([VariableC]),0,ROWNO(TOTAL)))

 

RANGESUM(ABOVE(SUM([VariableC]),0,ROWNO()))

 

They both return the exact  same values as VariableC, not an accumulation. Can someone help me?

Thank you! 

0 Replies