Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to calculate Opening and closing balance in a straight table. But stuck at getting above row value.
Please help here.
Go to Solution.
See attached example.
Change to pivot Table and use
above(sum([Opening Balance])+Sum([Debit Amount])-Sum([Credit Amount]))
Above works on dimension so if you have 3 dimension it will give value based on all dimensions
Thanks a ton Gysbert!!!