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: 
amien
Specialist
Specialist

Get last value of the running sum in a seperate column

I have this in expression #3

If(Above(TOTAL code) <> code,

Sum(Value),

Rangesum(

Sum(Value),

Above(TOTAL Column(3))

)

)

This gives me a running sum for each code. And it breaks/resets on each code.

Each code now has a final running sum value.

I want this final runningsum value in column 4. This would mean i have many times the same value for each code

How can i do this?

Thanks in advanced

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Use

SUM(Total <Code> Value)

View solution in original post

1 Reply
MK_QSL
MVP
MVP

Use

SUM(Total <Code> Value)