Discussion Board for collaboration related to Creating Analytics for QlikView.
I want Pivot Table as following:
TrasactionNo Date MainBalance Dr Cr CurrentBalance
1 15-1-11 1000 100 - 900
2 16-1-11 900 100 - 800
3 16-1-11 800 - 500 1300
In the above case my each CurrentBalance become the MainBalance for next column.
So please proivde me any solution for that.
Thanks & Regads,
Try using above() function
I want my current balance as a MainBalance in next row.
I have use the following set exp
its working only for First four records which having same date, if date changes then its not showing any value.