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