topic Re: Subtotal Incorrect in pivot table in QlikView

Subtotal Incorrect in pivot table

pgalvezt — Tue, 03 Jul 2018 19:41:23 GMT

Hello,

I have change the position 1 value in the budget, that´s work fine, but the problem is that the new subtotal don´t show the real value. (Its not doing anything). 114506 was in the "So" position.

I attached an image for better visualization.

If(if(seg='Al',zo,if(se = 'Ju',Pa,Agr2))= 'S'

And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',0,

If(if(seg='Al',zo,if(seg = 'Ju',Pa,Agr2))= 'C'

And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',

Sum(Aggr(sum(plan),Loc)),

num(

RangeSum(sum(if(idPer=1,plan*1.19)/Mol),sum(if(idPer=2, plan/1.19)))*$(xUfMaxMes)

,if(Vis='UF','#.##0,0000' ,'#.##0'))))

Thanks!

Re: Subtotal Incorrect in pivot table

BalaBhaskar_Qlik — Wed, 04 Jul 2018 07:09:02 GMT

may be:

Sum(aggr(distinct sum(plan),loc))

Re: Subtotal Incorrect in pivot table

pgalvezt — Wed, 04 Jul 2018 22:46:49 GMT

I got it. the solution was to add sum aggr around the whole IF:

Sum(Aggr(