topic Re: Above function on Expression in QlikView https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897966#M470390 <HTML><HEAD></HEAD><BODY><P>Thanks a ton Gysbert!!!</P></BODY></HTML> Wed, 20 May 2015 13:32:42 GMT rajni_batra 2015-05-20T13:32:42Z Above function on Expression https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897963#M470387 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I am trying to calculate Opening and closing balance in a straight table. But stuck at getting above row value.</P><P></P><P>Please help here.</P></BODY></HTML> Wed, 20 May 2015 12:25:40 GMT https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897963#M470387 rajni_batra 2015-05-20T12:25:40Z Re: Above function on Expression https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897964#M470388 <HTML><HEAD></HEAD><BODY><P>Change to pivot Table and use</P><P>above(sum([Opening Balance])+Sum([Debit Amount])-Sum([Credit Amount]))</P><P></P><P></P><P>Above works on dimension so if you have 3 dimension it will give value based on all dimensions</P></BODY></HTML> Wed, 20 May 2015 12:59:28 GMT https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897964#M470388 robert_mika 2015-05-20T12:59:28Z Re: Above function on Expression https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897965#M470389 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Wed, 20 May 2015 13:11:36 GMT https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897965#M470389 Gysbert_Wassenaar 2015-05-20T13:11:36Z Re: Above function on Expression https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897966#M470390 <HTML><HEAD></HEAD><BODY><P>Thanks a ton Gysbert!!!</P></BODY></HTML> Wed, 20 May 2015 13:32:42 GMT https://community.qlik.com/t5/QlikView/Above-function-on-Expression/m-p/897966#M470390 rajni_batra 2015-05-20T13:32:42Z