Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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