topic Re: Partial sum in pivot does not match with excel sum in QlikView

Partial sum in pivot does not match with excel sum

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Attaching a sample QV file, in which if I export the pivot table in excel and check the sum of expression column it does not match with partial sum in pivot.

Excel sum is correct which I need on pivot partial sum.

Is there any way to achieve this without changing the dimensions.

Thanks in advance.

Re: Partial sum in pivot does not match with excel sum

swuehl — Sat, 14 May 2016 11:56:25 GMT

Use this as expression:

=sum(Aggr(If(Value1-Value2, Value1-Value2-Value3,0),Company,Ref))

Re: Partial sum in pivot does not match with excel sum

sunny_talwar — Sat, 14 May 2016 11:57:51 GMT

Try this:

=Sum(Aggr(If(Sum(Value1)-Sum(Value2) <> 0, Sum(Value1)-Sum(Value2)-Sum(Value3),0),Company,Ref))

Re: Partial sum in pivot does not match with excel sum

Anonymous — Sat, 14 May 2016 12:44:17 GMT

Thanks a lot both of you

Both the solutions worked like magic on my original file also.