topic Incorrect totals in a pivot table in QlikView

Incorrect totals in a pivot table

Thu, 17 Dec 2009 01:53:21 GMT

I am getting incorrect totals in my pivot table:

	Calendar Year	2009
Beginning Fleet Indicator	Calendar Month	Jan
Non-Fleet		26837
Fleet		1941
Total		28431

Dimensions are Beginning Fleet Indicator, Calendar Year and Calendar Month. I am using Parial Sum for Beginning Fleet Indicator.

The expression looks like this:

Sum

({$<[Calendar Year] = {$(=Max([Calendar Year]))}, Inforce = {'Y'}>} [Customer Counter])

Incorrect totals in a pivot table

johnw — Thu, 17 Dec 2009 03:31:00 GMT

If you're certain you just want the sum of the rows, you should be able to do it by adding the underlined part (untested):

sum(aggr(sum({<[Calendar Year]={$(=max([Calendar Year]))},Inforce={'Y'}>} [Customer Counter])
,[Beginning Fleet Indicator],[Calendar Year],[Calendar Month]))

Pivot tables generally don't do sums of rows. They simply apply the expression again. In this case, do you perhaps have 347 customers that were both fleet and non-fleet in January 2009? I suspect that would cause what you are seeing, as by default, it wouldn't double-count those customers. Might be something else, of course.

Incorrect totals in a pivot table

Thu, 17 Dec 2009 03:57:05 GMT

Great. That did it. Thanks.