Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

rajni_batra
Valued Contributor

Above function on Expression

Hi Folks,

I am trying to calculate Opening and closing balance in a straight table. But stuck at getting above row value.

Please help here.

1 Solution

Accepted Solutions

Re: Above function on Expression

See attached example.


talk is cheap, supply exceeds demand
3 Replies

Re: Above function on Expression

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

Re: Above function on Expression

See attached example.


talk is cheap, supply exceeds demand
rajni_batra
Valued Contributor

Re: Above function on Expression

Thanks a ton Gysbert!!!

Community Browser