topic Chart Expression in QlikView

Chart Expression

Mon, 05 Aug 2013 07:04:14 GMT

Hi there,

I have an Gauge Chart whiche works. I have some datas which are 0.00 and it would be great if the chart ignores the 0.00 that it does not pushing down the avg. The Expression is Avg(Value).

Re: Chart Expression

Anonymous — Mon, 05 Aug 2013 07:07:04 GMT

Try an expression that tests for Value not being 0. Something like:

avg({<Value='{<>0}'>} Value)

... or using an if statement ...

Avg(if(Value<>0, Value))

Jonathan

Re: Chart Expression

Mon, 05 Aug 2013 07:16:42 GMT

Thanks Jonathan

I tried the first expression, it didn't worked. It showed nothing.

With Avg(if(Value<>0, Value)) it workes fine.

And also thank you for the fast answer

Re: Chart Expression

Mon, 05 Aug 2013 09:54:32 GMT

Try this if you dont want the If-statement.

Avg({<Value-={0}>}Value)