topic Re: Pivot table total column not correct in QlikView

Pivot table total column not correct

Anonymous — Wed, 14 Mar 2018 18:47:18 GMT

I have a pivot table that has 4 dimensions and I am showing partial sums on all the column. I can see the totals per column on the bottom and then i also have a total at the far right. The total at the far right does not equal the sum of all the column totals.

I have pulled one dimension to the top, so it is breaking the columns up into the dimensions. I am attaching a picture of what the columns look like and the total.

This is also happening on a less complex pivot table. See second attachment qlikview2. I am using distinct in my expressions in both charts could this be a factor?

Re: Pivot table total column not correct

YoussefBelloum — Thu, 15 Mar 2018 00:01:26 GMT

Hi,

try this first on the least complex pivot table:

example you have Sum of something: sum(Field)

now add the red part outside the sum:

Sum(Aggr( Sum(Field), ALL_THE_DIMENSIONS_USED_ON_THE_TABLE))

Sum(Aggr( Sum(Field), Dimension1,Dimension2,..))

Re: Pivot table total column not correct

Anonymous — Thu, 15 Mar 2018 13:43:28 GMT

what if the dimensions are all calculated dimensions? Do I just put the field I am calculating on?

Re: Pivot table total column not correct

YoussefBelloum — Thu, 15 Mar 2018 14:21:35 GMT

Yes, give it a try and tell me