topic Re: Pivot table total error in QlikView

Pivot table total error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello ,

I have a pivot table, the total sum of a column that contains a formula, is not correct, gives an incorrect number, in this case I should add 233 and not 208.

}

The expression of that OBJ column is the following:

if ((Country = 'BB' or Country = 'BS' or Country = 'JM' or Country = 'TT' or Country = 'AW'),

if (TYPE_Client = 'PRES',

if (sum (Vp) <= 208, Sum (Vp), 208), sum (Vp)), sum (Vp))

I appreciate your recommendations.

Re: Pivot table total error

sunny_talwar — Wed, 29 Nov 2017 19:15:50 GMT

Try this

Sum(Aggr(

if ((Country = 'BB' or Country = 'BS' or Country = 'JM' or Country = 'TT' or Country = 'AW'),

if (TYPE_Client = 'PRES',

if (sum (Vp) <= 208, Sum (Vp), 208), sum (Vp)), sum (Vp))

, Representante, Ruta_O, Fuerza, Ciclo, TIPO_Cliente))

Re: Pivot table total error

Anonymous — Wed, 29 Nov 2017 20:18:57 GMT

Thanks Sunny

I just make a change, but now, I am seeing values as 0 as you can see in the table.

Re: Pivot table total error

sunny_talwar — Wed, 29 Nov 2017 21:29:55 GMT

Do you have another dimension in your chart? Or is any of the dimension a calculated dimension? Would you be able to share a sample to check this out?

Re: Pivot table total error

Anonymous — Wed, 29 Nov 2017 22:43:21 GMT

No, any dimension is calculated,

Re: Pivot table total error

Anil_Babu_Samineni — Thu, 30 Nov 2017 01:23:12 GMT

Are you labeling using Expressions? Would you mind can you attach sample? Where and why it's not working we will test for you

Re: Pivot table total error

sunny_talwar — Thu, 30 Nov 2017 01:26:19 GMT

You seem to have only 4 dimensions? Again, I can only see what you share, but try this

Sum(Aggr(

if ((Country = 'BB' or Country = 'BS' or Country = 'JM' or Country = 'TT' or Country = 'AW'),

if (TYPE_Client = 'PRES',

if (sum (Vp) <= 208, Sum (Vp), 208), sum (Vp)), sum (Vp))

, Representante, Ruta_O, segfuerza, DesCiclos))

Basically, you need to use all your dimensions from the chart in the last line of the expression above

Re: Pivot table total error

Anonymous — Fri, 15 Dec 2017 17:00:11 GMT

Hi Sunny , i forgot to thanks you, now is working fine, thank very much for your help. I like a lot this community and talk with the experts.

regards,