topic Error total sum field calculated in QlikView

Error total sum field calculated

Mon, 26 Jan 2026 18:19:17 GMT

Dear all,

I have a problem with a pivot table

I have 3 fields and I want to add like this:

if(sum(Field 1)+Sum(Field 3) > Sum(field 2),sum(Field 1)+Sum(Field 3),Sum(field 2))

It work for dimensionality()=6 but for dimensionality()=1 it gets the greater of Sum(Field 1) + Sum(Field 3) or Sum(field 2) and not the sum of the values.

What can i do?

Best regards

Error total sum field calculated

prieper — Sun, 27 Feb 2011 19:35:35 GMT

Not quite clear - can you post an example.
In first instance would change the order of the aggregation and the condition, like SUM(IF ...)

++
Peter

Error total sum field calculated

Mon, 28 Feb 2011 09:05:37 GMT

Can you share you apllication , as it little difficult to undersatnd here 🙂

Error total sum field calculated

Mon, 28 Feb 2011 09:08:50 GMT

Dear Ashwin,

here you have a simple example

LOAD * INLINE [

F1, F2, F3,F4

1, 2, 6,D1

2, 1, 1,D2

];

Last field on total sum must be 9 and not 7

F4	Sum (F1)+Sum (F2)	Sum (F3)	if(Sum (F1)+Sum (F2)>Sum(F3),Sum (F1)+Sum (F2),Sum(F3))
D1	3	6	6
D2	3	1	3
Total	6	7	7

Error total sum field calculated

prieper — Mon, 28 Feb 2011 11:20:09 GMT

Not sure, whether workable in a Pivot-Table.
In a straight table you may declare the calculation not as "Expression Total", but as "Sum of Rows".

HTH
Peter

Error total sum field calculated

lironbaram — Mon, 28 Feb 2011 11:30:08 GMT

you need to do an aggr function in pivot table

something like sum(aggr(if(Sum (F1)+Sum (F2)>Sum(F3),Sum (F1)+Sum (F2),Sum(F3)),F4))

Error total sum field calculated

Mon, 28 Feb 2011 11:43:32 GMT

Hi ,

As per your expression its showing 7. but when you will do sum of Row's in straight table. It will give to your result.

In pivote it will work with aggr function

please find attach application.