Sum of rows below in qlikview

First we need to sort our data.

Second we need to select previous total and add current amount + add condition.

Third we need sort our table way as we like (newest on top).

Most important function used is Peek.

// example data (I simplified data)
[data]:
LOAD 
    * 
INLINE [
    Date, Amount
    6, 300
    5, 200
    4, -100
    3, -500
    2, 200
    1, 100
];

// order as we need use data from previous row correctly
[data_ordered]:
NoConcatenate LOAD 
    *
Resident
    [data]
Order by 
    Date asc;
    
DROP Table [data];

// condition, peek function and alt needed for first row where is no data yet
[data_totals]:
LOAD
    Date,
    Amount,
    If((Amount + Alt(Peek('Total', -1), 0)) > 0,
        Amount + Alt(Peek('Total', -1), 0),
        0) as Total
Resident
    [data_ordered];
    
DROP Table [data_ordered];

final table: