Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
upaliwije
Contributor II

GRAND TOTAL IN PIVOT TABLE

Hi friends

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.

1 Solution

Accepted Solutions

Re: GRAND TOTAL IN PIVOT TABLE

Try these expressions with show partial sums checked

Sum(Aggr(if(sum(GLT_AMOUNT)>0,SUM(GLT_AMOUNT),0), GLT_AC_CODE, ACCOUNT_NAME))

and

Sum(Aggr(if(sum(GLT_AMOUNT)<0,SUM(GLT_AMOUNT)*-1,0), GLT_AC_CODE, ACCOUNT_NAME))
1 Reply

Re: GRAND TOTAL IN PIVOT TABLE

Try these expressions with show partial sums checked

Sum(Aggr(if(sum(GLT_AMOUNT)>0,SUM(GLT_AMOUNT),0), GLT_AC_CODE, ACCOUNT_NAME))

and

Sum(Aggr(if(sum(GLT_AMOUNT)<0,SUM(GLT_AMOUNT)*-1,0), GLT_AC_CODE, ACCOUNT_NAME))