Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

teodora88
New Contributor II

Incorrect totals in Pivot Table Qlik Sense

Hello,

i use pivot table but i can't see the correct numbers for my totals.

Can somebody explain me how to fix that?

Untitled.png

7 Replies

Re: Incorrect totals in Pivot Table Qlik Sense

Why do you think the totals are incorrect? What values do you expect instead?


talk is cheap, supply exceeds demand
teodora88
New Contributor II

Re: Incorrect totals in Pivot Table Qlik Sense

If you sum (123+188+6)= 316  and what we are able to see for total in my table is 108.  108 is different from 316. Untitled5.png

awhitfield
Esteemed Contributor

Re: Incorrect totals in Pivot Table Qlik Sense

That field an AVG isn't it? So why would it SUM UP?

Andy

teodora88
New Contributor II

Re: Incorrect totals in Pivot Table Qlik Sense

The client wants to see the total amount, but next field is target and the the problem is the same. The totals values aren't correct.

Re: Incorrect totals in Pivot Table Qlik Sense

If you want a sum of averages the you need to use the aggr function. Something like sum(aggr( original_expression_here , Channel, Stream))


talk is cheap, supply exceeds demand
quriouss
Contributor III

Re: Incorrect totals in Pivot Table Qlik Sense

I suspect that probably *is* correct - it depends on how you are defining your aggregation.  If those numbers are "per branch", then there is no reason that the totals should be the sum of the individuals.

Perhaps you could post the .qvf file (or an equivalent if you don't want to give the actual data)

gbechard
New Contributor

Re: Incorrect totals in Pivot Table Qlik Sense

Hello Teodora

I have the same problem as you

Did you get an answer or found a solution ?

Thanks a lot

Gilles

Community Browser