Compute the new column with the previous record value

[dwivedi_shashan]

Hi, 

I am new to qlikview and not able to achieve below result.

Basically I want to replace A value with the sum of A+B in previous record. 

I am aware of previous and preceding load but struggling to achieve the result. Please help. 

Old data                           New data

A         B                                A       B

5          2                                5         2

5           3                                7         3

5           4                               10       4

5           2                                14       2

[Vegar · Accepted solution]

Will this help you?

[New data]:
NoConcatenate Load
ALT(peek(A)+Peek(B), A) as A,
B
Resident
[Old data];
Drop table [Old data];

[Robison1B]

Hey, thanks for answering, i was also stuck at this point, your answer helped me. Thanks a lot krogerfeedback!

[dwivedi_shashan]

Thanks! It helped.