topic Re: Wrong Total in pivot-table in QlikView

Wrong Total in pivot-table

kris_vliegen — Wed, 30 Oct 2013 09:38:08 GMT

Hi All,

I've created a pivot-table

As you can see is the total for 'Totaal 2013' and 'Contant 2013' wrong and should be 1.222.861 and 467.162

I use this expression:

=if(sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) > 0,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) ,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}CapLiter))

And for Station-type and store set on 'Show Parttial sums'

Why is he counting the wrong numbers?

Regards,

Kris

Re: Wrong Total in pivot-table

Gysbert_Wassenaar — Wed, 30 Oct 2013 17:03:16 GMT

I think you'll have to wrap your expression in another sum:

=sum({ $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >} aggr(

if(sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) > 0,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) ,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}CapLiter)),

Dim1, Dim2, ... , DimN))

Replace Dim1, Dim2, ... , DimN with the dimensions of your pivot table

Re: Wrong Total in pivot-table

kris_vliegen — Thu, 31 Oct 2013 11:02:14 GMT

Thanks, this seems to work!

Regards,

Kris