Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
dwivedi_shashan
New Contributor II

Compute the new column with the previous record value

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

Labels (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Compute the new column with the previous record value

Will this help you?

[New data]:
NoConcatenate Load
ALT(peek(A)+Peek(B), A) as A,
B
Resident
[Old data];
Drop table [Old data];
???
Celebrating my 300 accepted solution in the Qlik Community
???
3 Replies
Partner
Partner

Re: Compute the new column with the previous record value

Will this help you?

[New data]:
NoConcatenate Load
ALT(peek(A)+Peek(B), A) as A,
B
Resident
[Old data];
Drop table [Old data];
???
Celebrating my 300 accepted solution in the Qlik Community
???
Robison1B
New Contributor

Re: Compute the new column with the previous record value

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

dwivedi_shashan
New Contributor II

Re: Compute the new column with the previous record value

Thanks! It helped.