topic Re: Compute the new column with the previous record value in QlikView

Compute the new column with the previous record value

dwivedi_shashan — Sat, 16 Nov 2024 20:39:41 GMT

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 — Sun, 16 Jun 2019 06:04:53 GMT

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 — Tue, 18 Jun 2019 09:25:34 GMT

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

dwivedi_shashan — Mon, 17 Jun 2019 19:11:10 GMT

Thanks! It helped.