Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table sum up metrics/expressions

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

1 Reply
marcus_sommer

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