topic Wrong total in pivot table in QlikView

Wrong total in pivot table

Wed, 06 Mar 2013 23:08:55 GMT

I have an pivot table with this value. In the column "if sum" i want to display sumA if is >=1 or sumB if is <=0.

When i collapse the dimension Agent or Customer the sub total is wrong. It do the total of the total of sum a or sum b and not the total of the colum "if sum"

how can i do?

AGENT	customer	SUM(A)	SUM(B)	if sum
Agent1	customerA	0	7	7
Agent1	customeG	0	10	10
Agent1	customeL	9	10	9
Agent1	customeR	5	10	5
Agent2	customeB	5	10	5
Agent2	customeF	5	10	5
Totale		24	57	41

Re: Wrong total in pivot table

CELAMBARASAN — Wed, 06 Mar 2013 23:18:52 GMT

Can you tell me the data input? data displayed in the pivot without collapse?then after collapse?

On observing your table is it returns 14 for Agent1 on collapsing Agent1?

Re: Wrong total in pivot table

Wed, 06 Mar 2013 23:55:49 GMT

the value for total are 41 with collapse and 24 when i see the total for the uncollapse dimension

such as 14 agent1 and 10 agent2.

i would optain 31 for agent1 (14 from sum1 and 17 from sum b) and 10 for agent2

now with the expression if(sum A >=, sum(A), sum (b)) i return me a wrong result if i uncollapse the dimension

Re: Wrong total in pivot table

Gysbert_Wassenaar — Thu, 07 Mar 2013 09:25:36 GMT

See attached qvw

Re: Wrong total in pivot table

Thu, 07 Mar 2013 16:54:47 GMT

thanks