how to use one field value in second column that is in another column

[Anonymous]

Header 1	Header 2	Header 3	Header 4
BANK_ID	DATE	OPENING BALANCE	CLOSING BALANCE
1	1/8/2016	7M	8M
1	2/8/2016	---

I have this table i have only one Opening balance for 1/8/2016 i want to populate the next opening balance which should be previous closing balance ie opening balance for 2/8/2016 should be 8M which is the closing balance of the previous date..i am new to qlik please help me.

[sunny_talwar]

On the script level you can use Peek() vs Previous() – When to Use Each and on the front end you can use Missing Manual - Above() and Below(). For more help would you be able to share a sample where you are trying this?