topic Re: Round off issue in Pivot Table in QlikView

Round off issue in Pivot Table

Wed, 14 May 2014 13:04:31 GMT

Hi All,

We are using a Pivot Table, and in the Pivot table we are making the expression as Integer. Also we are displaying the total of the values.

But the total and sum of individual values are not matching ( given below in yellow).

Data in the Pivot table given below. Please could you advise?

Business Unit	Total	1	2	3	4	5	6	7	8
A	40979	23	3	0	6447	-	1539	318	32649
B	94010	20	21	53	14318	17	2604	5398	71579
C	60023	3	-	345	22931	233	10	3378	33124
D	52796	18	284	2	4346	-	190	3304	44652
E	112089	297	6	-	9588	-	148	3411	98639
F	43348	25	-	191	8433	-	11	3045	31642

Thanks,

Sijo Joseph

Re: Round off issue in Pivot Table

Wed, 14 May 2014 13:27:13 GMT

Try wrapping your expression in the ROUND() function instead of using the 'Integer' option.

Here is some more info on the ROUND() function:

Round up

Re: Round off issue in Pivot Table

hic — Wed, 14 May 2014 13:37:15 GMT

There are several things that could cause this.

First, the for the total, the rounding is made after the calculation of the total. This could explain why it says 60023 when the 8 columns sum to 60021.

Secondly, the total does not sum the 8 rows - instead it sums all the records in the background. So, if a specific transaction due to the data model can belong to more than one column, the amount will be counted twice in the columns but only once in the total.

Thirdly, if your expression uses an unaggregated field reference, this might be well defined on the lowest level in the pivot, and then the row will contribute to the number. But it may not be well defined in the total and then the row will not contribute.

You need to post a sample app if we are to find out where the problem is.

HIC