topic Help with Pivot table in QlikView

Help with Pivot table

Thu, 06 Sep 2012 05:46:00 GMT

In Pivot table if we have selected to show the partial sum then it automatically sum ups the group values, is there any way to skip this. I want to show the total but not the summation of group values, some other mathematical calculation result; is it possible.

Re: Help with Pivot table

thomas_skariah — Thu, 06 Sep 2012 05:48:39 GMT

Hi Ram,

Can you forward a sample application.

Regards,

Tom

Re: Help with Pivot table

jonathandienst — Thu, 06 Sep 2012 06:20:42 GMT

You can use Dimensionality() to identify the total rows and create an expression that use Dimensionality like this:

If(Dimensionality() = 0, <total row expression here>, <detail row expression here>)

If you have more than one dimension, then the value of Dimensionality will equal the number of dimensions for the detail rows. The partial sums will have Dimensionality values between one less than the number of dimensions to 0, according to the partial sum level. The total row, or partial total row expression will often be a Sum(Aggr()) type of expression.

If you provide more information on your requirements, then we can help you with the expression.

Hope that helps

Jonathan

Re: Help with Pivot table

Thu, 06 Sep 2012 06:29:25 GMT

Hi Ram,

Please find the attached table and let me know if you require the result as follows.

Afghanistan	Olivier Simenon	2007	2150
Albania	John Lemon	2006	6000
Albania	John Lemon	2008	2590
Armenia	Mario Kaddafi	2007	1850
Australia	Rolf Wesenlund	2005	1030
Australia	Rolf Wesenlund	2006	1210
Total			14830

Regards

Mayank