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: 
rmangali
Contributor
Contributor

Running Balance

Hi everyone,

Been working for days and can't seem to find the right way to do a running balance.

This is the output I'm trying to achieve:

Total

Balance

10852

10852

1

10851

1

10850

2

10848

3

10845

5

10840

5

10835

10

10825

10

10815

10

10805

10

10795

20

10775

20

10755

25

10730

25

10705

50

10655

60

10595

5

10590

8

10582

I need to add an expression balance as shown above to the attached chart.

I tried RangeSum(Above(Total),0,RowNo()) but it's adding, not subtracting.

Thanks in advance.

-R

0 Replies