topic Re: Grand total in pivot (calculating dependency) in QlikView

Grand total in pivot (calculating dependency)

bartvanwetten — Tue, 16 Sep 2014 13:24:38 GMT

Dear all,

in attached document you'll see a pivot table. Depending on (no) values in column [ds%] the [Kg at 88%] is calculated.The values in that column [Kg at 88%] are correct. Except for the Grand Total which should be 2.115.293, which is the sum of all subtotals, instead of what qlikview calculates. (1.240.284)

Can anybody help me out on this one?

Thx in advance!

Bart

Re: Grand total in pivot (calculating dependency)

Anonymous — Tue, 16 Sep 2014 14:01:33 GMT

you need add Aggr function to the expression.

Sum(

Aggr(

if(sum(r4_ds)=0,

(if(sum({< Rekening_Groep={'Aankoop voer'}>} r4_gewicht)<>0,

sum({< Rekening_Groep={'Aankoop voer'}>} r4_gewicht)

))

(if(sum({< Rekening_Groep={'Aankoop voer'}>} r4_gewicht)<>0,

sum({< Rekening_Groep={'Aankoop voer'}>} r4_gewicht)

))

(

if(sum({< Rekening_Groep={'Aankoop voer'}>} r4_gewicht)<>0,

if(avg({< Rekening_Groep={'Aankoop voer'}>}if(r4_ds<>0,r4_ds))<>0,

avg({< Rekening_Groep={'Aankoop voer'}>}if(r4_ds<>0,r4_ds)) & '%'

))

)

/.88)

,Grootboek_Grootboekomschrijving, Transactie_Periode))

Re: Grand total in pivot (calculating dependency)

bartvanwetten — Tue, 16 Sep 2014 14:21:21 GMT

Hi Konstantins!

Thank you so much for the right answer!

Kind regards,

Bart