topic Re: Pivot Table Summation issue in QlikView

Pivot Table Summation issue

Fri, 24 Apr 2015 05:48:20 GMT

Hi All,

I have one pivot table with count of values, in this i have used grouping and shown group total based on dimensions. In that the individual dimension values are coming correct but the group total summation values are coming wrong. Any ideas on why this happening? Any suggestions on how to resolve this?

Re: Pivot Table Summation issue

PrashantSangle — Fri, 24 Apr 2015 05:52:19 GMT

Hi,

USe

Count(Aggr(Count(Values),Dimesion1,Dimesion2))

Regards

Re: Pivot Table Summation issue

jonathandienst — Fri, 24 Apr 2015 06:04:35 GMT

I suggest that you post details of the pivot table dimensions, expressions and partial sums settings at the very least. Better still and for more accurate help, upload a sample qvw with the pivot table and a sample of your data.

And please don't cross post your request to more than one forum site.

Jonathan