topic Re: Wrong total in pivot table in QlikView

Wrong total in pivot table

pgalvezt — Mon, 01 Oct 2012 20:38:55 GMT

Hello, I'm Having a different result from the pivot table. I have had reading about this. I think I have to use the aggr advanced function.

But Doesn't work

19,462,283
6,109,388
2,342,810
1,062,468
-271,798
-271,798
-253,340
29,810,800

My Formula is: the sum should have

28.180.013

and not 29810800

=(Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

Thank you!

Re: Wrong total in pivot table

hic — Mon, 01 Oct 2012 21:30:42 GMT

I don't think you need the aggr function. I think the problem is that you divide the Sum(...) with Divisor, which is an unaggregated number. This causes problems in all cases where there is more than one possible value of Divisor. You should either move the division into the Sum(...) or you should divide with Avg(Divisor).

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/03/the-only-function

HIC