10 Replies Latest reply: Jun 8, 2015 8:39 AM by Mathieu LAURIER

# Problem of Total

Hello,

In a pivot table, the Total is null exclude one ligne (the red one). Can you tell me why?

Thank you very much.

 ID IP Nombre [% Nombre] Total 1 Total A1 961 84,82% B1 1 100,00% 2 Total A1 3625 99,44% B1 9 50,00% 3 Total Adami 2 100,00% A1 58 43,29% B1 225 85,23% 4 Total A1 135 51,85% B1 156 92,31% 5 Total A1 1044 95,68% B1 69 95,83% 6 Total 223 81,17% A1 223 81,17% 7 Total A1 0 0,00% B1 39 95,24% 8 Total 0 0,00% A1 35 100,00%
• ###### Re: Problem of Total

Hi,

Regards

• ###### Re: Problem of Total

in the Pivot table - presentation, I choosed just " show partial sums".

• ###### Re: Problem of Total

Hi,

You expression for calculating Nombre

Is it just fieldName or you use Sum(Nombre)

Regards

• ###### Re: Problem of Total

It looks like your expression cannot be evaluated at the total level. This could be due to a number of reasons - for example

• naked fields (fields not enclosed in an aggregation function like Sum or Max). The naked field values cannot be evaluated at a total (aggregated) level unless there is only one possible value.
• An invalid arithmetic operation. For example, a division that works at a detail level, but whose divisor totals to zero, leading to an invalid divide by zero.

I suggest that you post an example qvw that illustrates the problem, or at least provide full information on the expressions, dimensions and data structure of your model.

• ###### Re: Problem of Total

I think Jothan are on the correct track and I seen this on several applications where an aggr have been used, in combo with a pivot table, an incorrect way where it works on row level but cant be evaluated on total.

• ###### Re: Problem of Total

pls share ur .qvw?tht help't to quick reply!

• ###### Re: Problem of Total

Hello, I find the problem, but I can't understand why we have to do that.

In fait, I have a table (1), I import it into Qlikview, I want just a pivot table as table (2).

At the first, in the expression, I used just " N1 ", that's why the total is null as table (3),

in fait, in the expression, we have to use " sum(N1) ", even in this cas Sum(N1) is equal to N1.

The reason is not very clair to me, sommeone can explain it ? Thank you.

(1)

(2)

(3)

• ###### Re: Problem of Total

Hi,

The default (only) mode of total sum in a pivot table is based on the expression (expression total) and for that reason you will not get a correct sum value if you using a non calculating expression to validate/expand the dimension(s). Ina straight table can you change how the total mode is calculated and are therefor able to choose sum(N1) as a mode, instead of change the expression itself.