topic Re: pivot table sum up metrics/expressions in QlikView

pivot table sum up metrics/expressions

Fri, 09 Dec 2016 18:58:43 GMT

Hi,

I have a pivot table, which has around 20 measures/expressions. I want to add a new column to the pivot table which will sum up the values in the last 10 expressions/measures.

Ofcourse one way is to add them like this

Column(10) + Column(11)+.............Column(20)

Is there some way to easily do this kind of summation. For example using rangesum etc?

Shah

Re: pivot table sum up metrics/expressions

marcus_sommer — Sat, 10 Dec 2016 13:38:36 GMT

Rangesum(column(10), column(11), ...) would be probably better then just adding the columns because NULL would be within the rangesum treated as 0 instead of returning NULL for the whole row. In cases that the columns could move it might be considerable to use the expression-labels instead of the column-index.

I think more wouldn't be possible unless you could use a dimension instead of many expressions and then enabling from partial sums (but I assume that wouldn't be suitable in your case).

- Marcus