Discussion Board for collaboration related to QlikView App Development.
I have attached my qv document here. In my document I have sheet 'TB'. In this sheet I have created a pivot table. But I am unable to show value in Total Row although I have ticked 'Show partial sum' in the presentation tab. Kindly help me.
Go to Solution.
Try these expressions with show partial sums checked
Sum(Aggr(if(sum(GLT_AMOUNT)>0,SUM(GLT_AMOUNT),0), GLT_AC_CODE, ACCOUNT_NAME))
Sum(Aggr(if(sum(GLT_AMOUNT)<0,SUM(GLT_AMOUNT)*-1,0), GLT_AC_CODE, ACCOUNT_NAME))