topic Table Chart expression total in QlikView

Table Chart expression total

Fri, 08 May 2009 00:52:26 GMT

Hi,

I have a simple table chart containing dimensions and several calculated expressions. I need to total up the expressions (about 18 in total) into another column in the table. numsum does not do the trick. Any other ideas?

Thanks!

Table Chart expression total

johnw — Fri, 08 May 2009 01:05:17 GMT

Maybe I'm missing something, but column(1) + column(2) + column(3) + ... + column(18)?

Table Chart expression total

Fri, 08 May 2009 02:09:02 GMT

That doesn't work, I've tried it. the columns are calculated expressions.

Table Chart expression total

Anonymous — Fri, 08 May 2009 02:19:32 GMT

It doesn't matter. Use expression names in place of John's column(n). Or write a new expression like this:
<expression of column 1> + <expression of column 2> +...

Table Chart expression total

johnw — Fri, 08 May 2009 02:31:07 GMT

I don't know why it wouldn't work. It works just fine for me where the columns are calculated expressions. See the attached. Is it possible to post an example of the problem you're seeing? Alternatively, does my example show you that I'm misunderstanding your question, and if so, can you clarify?

Table Chart expression total

Oleg_Troyansky — Fri, 08 May 2009 02:38:33 GMT

It might not work if some of the columns return nulls - then the whole expression is rendered as null. The way around it is using rangesum:


=rangesum(Column(1), Column(2), ..., Column(18))

Table Chart expression total

johnw — Fri, 08 May 2009 02:41:28 GMT

Ah! Of course. Good point. That could easily be the problem.