topic Re: Creating an average from chart expressions in QlikView

Creating an average from chart expressions

Mon, 17 Nov 2014 12:11:12 GMT

Hi,

I've created several expressions from which I need an overall average.

The sum expression I've created is a simple addition:

Expression1 + Expression2 + Expression3 .........

However, the expression only gives a value if all the expressions have a value. How do I get a total/average if any of the constituent expressions is missing?

Any help on this gratefully received,

Racine62

Re: Creating an average from chart expressions

marcus_malinow — Mon, 17 Nov 2014 12:12:59 GMT

try using

rangemax(Expression1, 0) + rangemax(Expression2,0) etc.. etc...

Re: Creating an average from chart expressions

maxgro — Mon, 17 Nov 2014 12:15:34 GMT

look at alt function

the result of alt(null(), 0) is 0

or at the rangesum function

from online help

rangesum(expr1 [ , expr2, ... exprN ])

Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.

Re: Creating an average from chart expressions

Mon, 17 Nov 2014 13:17:19 GMT

Thanks for this,

Racine62