Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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