topic Re: Displaying %'s in a pivot table in QlikView

Displaying %'s in a pivot table

Thu, 03 Sep 2015 08:18:38 GMT

Is it possible? I have a pivot table that details Month which expands to Date which then expands to Reason for Call... please see screenshot...l

I did have this originally set up as a straight table and was using the expression =sum(CallCounter) and selecting the Relative checkbox for the % column but I don't have the Relative option for a pivot table. We received a total of 149 calls on 03/08/2015... how can I get Accounts Payable to show 3.36%, Allocation - General to show 7.38% and so on?

Many thanks in advance.

Re: Displaying %'s in a pivot table

Colin-Albert — Thu, 03 Sep 2015 08:25:42 GMT

Try sum(CallCounter) / sum(TOTAL CallCounter)

Re: Displaying %'s in a pivot table

alexandros17 — Thu, 03 Sep 2015 08:28:26 GMT

You must compute the percentage using aggr() function

Re: Displaying %'s in a pivot table

aveeeeeee7en — Thu, 03 Sep 2015 08:31:29 GMT

Your Expression would be:

=(Sum(CallCounter)/Sum(TOTAL CallCounter))/100

Than Go To Number Tab >

Select this expression > Fixed to 1 Decimal > Check Show in Percent Box.

Regards

Av7eN

Re: Displaying %'s in a pivot table

Thu, 03 Sep 2015 08:34:03 GMT

As simple as that eh Colin? Thanks so much for that