How to create Trail Balance, Profit & Loss & Balance sheet in QlikView

[sandy2671]

I want to create Trail Balance, Profit & Loss & Balance sheet in QlikView.

I have a requirement where i have take Closing Balance Amount of Previous Year will be the Opening Balance for Next Year on the basis of GL Account (Primary Key).

Suppose,

In 2009 GL Account No (110001) has Closing balance of 50,000 /- the balance comes from

Closing Balance =  [Opening amount +Debit Amount - Credit Amount],

Before 2009 there is no data .

I have to create a field named ''Closing Balance'' in which Closing Balance of Previous Year will be the Opening Balance for Next Year .

(For 2010, Closing Balance of 2009 will become opening balance for 2010)

Year	GL Account	GL Name	Opening Amount	Debit Amount	Credit Amount	Closing Amount(Op+Dr-Cr)
2009	110001	Share Capital	0	0	50000	-50000
2009	110002	Reserve and Surplus	0	0	100000	-100000
2010	110001	Share Capital	-50000	0	100000	-150000
2010	110002	Reserve and Surplus	-100000	0	100000	-200000
2011	110001	Share Capital	-150000	0	0	-150000