topic Re: Expression in text object in QlikView

Expression in text object

Fri, 13 Dec 2013 14:42:14 GMT

I have created the following expression in a text object:

= If(Delay>=0,NumericCount (Delay))

Expressions seems to be OK, but I doesn 't give a result.

= -

What could possibly be wrong ?

Thanks in advance.

Marc

datanibbler — Fri, 13 Dec 2013 14:43:20 GMT

Hi Marc,

that happens sometimes when your condition is not met and you have not specified an alternative in the IF construction.

swuehl — Fri, 13 Dec 2013 14:43:46 GMT

Try

= NumericCount (If(Delay>=0,Delay))

Fri, 13 Dec 2013 14:50:01 GMT

It works, thank you very much.

Grt

Marc

Fri, 13 Dec 2013 14:51:48 GMT

Your expression only works when you select Delay fields because your aggregation scope limited to only one value.

Please try: NumericCount(IF(Delay>0,Delay) --> In this the aggregation scope to total Field values.