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.
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.
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.