Setup Current and Previous period Amount at same row

[#1]

Hi QlikView eprts,

I have source table with columns, Date, Account, Amount. Want to transform that to following format of Date, Account, Amount, PY AMT (for further calculations).

Tried to read source table in two different table and then those two resident table into a single table to get PY AMT, using Join and Concatenate, but didn't get expected results.

Appreciate any insights on the approach to do this.

Source Data

TDATE	ACCOUNT	AMOUNT
1/1/2012	A CONSUMER INVESTMENT	14
1/1/2012	B CONSUMER INVESTMENT	157
1/1/2012	C CONSUMER INVESTMENT	351
1/1/2012	D CONSUMER INVESTMENT	25
1/1/2012	E CONSUMER INVESTMENT	13
1/1/2012	F CONSUMER INVESTMENT	28
1/1/2012	G CONSUMER INVESTMENT	49
1/1/2012	H CONSUMER INVESTMENT	0
1/1/2011	A CONSUMER INVESTMENT	7
1/1/2011	B CONSUMER INVESTMENT	78.5
1/1/2011	C CONSUMER INVESTMENT	175.5
1/1/2011	D CONSUMER INVESTMENT	12.5
1/1/2011	E CONSUMER INVESTMENT	6.5
1/1/2011	F CONSUMER INVESTMENT	14
1/1/2011	G CONSUMER INVESTMENT	24.5
1/1/2011	H CONSUMER INVESTMENT	0

Expected Format

TDATE	ACCOUNT	AMOUNT	PY AMT
1/1/2012	A CONSUMER INVESTMENT	14	7
1/1/2012	B CONSUMER INVESTMENT	157	78.5
1/1/2012	C CONSUMER INVESTMENT	351	175.5
1/1/2012	D CONSUMER INVESTMENT	25	12.5
1/1/2012	E CONSUMER INVESTMENT	13	6.5
1/1/2012	F CONSUMER INVESTMENT	28	14
1/1/2012	G CONSUMER INVESTMENT	49	24.5
1/1/2012	H CONSUMER INVESTMENT	0	0

Thanks,

Abhay

[MarcoARaymundo]

Sorry