Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
cas-ictp
New 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!