topic Help on partial sum of pivot table in QlikView

Help on partial sum of pivot table

Wed, 25 May 2011 07:01:46 GMT

Hi,

How can i get the grand total of individual dimension in a pivot table?

Thanks,

Rahul

Help on partial sum of pivot table

Wed, 25 May 2011 07:06:46 GMT

Hi,

In Properties - Presentation tab, below top-left side area, you can see "Show partial sums" tick box.

Select 1st dimension from list above that box and tick in this box.

You should get results you want.

Happy Thoughts

Help on partial sum of pivot table

raghavsurya — Wed, 25 May 2011 07:06:56 GMT

Hi Rahul,

You can achieve this in presentation tab by selecting the show partial sum for the dimension you want.

Regars,

Raghav

Re: Help on partial sum of pivot table

Wed, 25 May 2011 07:07:02 GMT

Hi,

In Properties - Presentation tab, below top-left side area, you can see "Show partial sums" tick box.

Select 1st dimension from list above that box and tick in this box.

You should get results you want.

Happy Thoughts

Help on partial sum of pivot table

Wed, 25 May 2011 07:36:03 GMT

Thank you all,

I've already done this...

I want the total to be 15.7 not 4.49.

Re: Help on partial sum of pivot table

Wed, 25 May 2011 07:55:01 GMT

I've already done this and i want the total to be 15.7 and not 4.49 for unit 'al'

Help on partial sum of pivot table

jonathandienst — Wed, 25 May 2011 08:24:46 GMT

If this were a straight table, you could change the Total Mode to Sum of rows (on the expression tab). In this case, though, you are using a pivot table and I don't tink that will work.

Change the expression to something like this (check closing brackets):

If(Dimensionality()=0,

Sum(Aggr(Sum(Days)/Count(distinct [EmployeeID]), Event)),

Sum(Days)/Count(distinct [EmployeeID]))

Dimensionality() will return 0 for the total and 1 for the normal rows (may be 1 and 2 in this case, I am not sure. Try =1 as well).

Regards

Jonathan

Re: Help on partial sum of pivot table

Wed, 25 May 2011 09:03:40 GMT

I've tried but it failed...

The file is attached for your reference.

Re: Help on partial sum of pivot table

jonathandienst — Wed, 25 May 2011 10:20:26 GMT

Actually did not need to use dimensionality in this case. See attachment which I think does what you need.

The new expression is:

Sum(Aggr(Sum(Days)/Count(distinct [Employee ID]), Event, Unit))

Jonathan