topic How to use partial sum in Pivot table in QlikView

How to use partial sum in Pivot table

Anonymous — Thu, 30 Aug 2012 06:39:46 GMT

Hi,

I am using Pivot table to show this type of excel data. The two dimension are Math and Percentage. My problem is that how can we show coulmn Average which contains average of only Percentage ,not Math. I also want to show Sum of all Percentage in last Row.

How can we achieve this in Qlikview.

Regards,

Samay

Re: How to use partial sum in Pivot table

Thu, 30 Aug 2012 07:53:58 GMT

could you send small sample qvw file?

Re: How to use partial sum in Pivot table

Anonymous — Thu, 30 Aug 2012 09:45:01 GMT

I have uploaded my sample file.

Sorry for Typo. I want to say that two expression are Math and Percentage in my preivous comment

Re: How to use partial sum in Pivot table

Thu, 30 Aug 2012 10:05:00 GMT

first case you can make by :

=if(Dimensionality()=2, Sum (Math),'')

as an expression

Re: How to use partial sum in Pivot table

Anonymous — Thu, 30 Aug 2012 11:47:27 GMT

Hi Pari,

Thanks for your quick reply.i tried ur solution but it does not work.

I want the same representation in qlikview as it is in attached image.i have to show only Avg of Percentage in Coulmn I , and Sum of Total percentage as in Row 13.

Re: How to use partial sum in Pivot table

Thu, 30 Aug 2012 13:53:01 GMT

see att file

it's almost exact what you want

i believe one extra row with Math in total will not be a problem:)

Re: How to use partial sum in Pivot table

Anonymous — Thu, 30 Aug 2012 17:09:13 GMT

thanks pari for your reply. this is exactly what i wanted. Thanks a lot again..:)