topic Totals in Pivot Chart show wrong sums in QlikView

Totals in Pivot Chart show wrong sums

innashna — Sat, 16 Nov 2024 00:19:05 GMT

Hi,

I have a Pivot Report where the Totals not correct.

For example, for PTD Date 07/13/2020 we see for differnet names -Total Orders 13 and Total Orders 19, but in Totals we see '-' instead of 32. Can you please help- the report is attached.

Re: Totals in Pivot Chart show wrong sums

Kushal_Chawda — Wed, 15 Jul 2020 12:27:34 GMT

What is the expressions used? May be in expression you have applied aggr function but did not apply relevant aggregation function on top of that.

Re: Totals in Pivot Chart show wrong sums

innashna — Wed, 15 Jul 2020 12:42:07 GMT

Hi,
This is the expression for total orders:
=if(flag_cease_cancel_orders=0,Count(DISTINCT DD_Solution_Leg_ID))

This is presentation tab:
[cid:image001.jpg@01D65ABE.5B6CC770]

Re: Totals in Pivot Chart show wrong sums

innashna — Wed, 15 Jul 2020 13:03:12 GMT

This is the presentation tab. - attached

Re: Totals in Pivot Chart show wrong sums

Kushal_Chawda — Wed, 15 Jul 2020 13:35:02 GMT

can you try this

Count({<flag_cease_cancel_orders={0}>}DISTINCT DD_Solution_Leg_ID)

=sum(aggr(if(flag_cease_cancel_orders=0,Count(DISTINCT DD_Solution_Leg_ID)), Dimension1,Dimension2))

where Dimension1,Dimension2 are pivot table dimension, you need to include all dimensions of pivot table