topic expression does not work when indicating a field needs to be empty. in QlikView

expression does not work when indicating a field needs to be empty.

Tue, 08 Nov 2011 09:42:04 GMT

I hope this is not a stupid question, but I tried and searched for half an hour and it still does not work.

Who can help me?

I have this as an expression on a bar-chart.

Count(if ( [Stage Type]='Transport' and [Event Type]='Order Confirmation' and [Plan / Actual]='Actual' and [Actual Time of Arrival]='' , Alert))

What here does not work is: [Actual Time of Arrival]=''

I only like to have the rows, where the [Actual Time of Arrival] does not have a value.

expression does not work when indicating a field needs to be empty.

Tue, 08 Nov 2011 09:58:51 GMT

Hi there,

[Actual Time of Arrival]=''

I believe that is looking for a zero string rather than a proper null, so it depends on what is in your data,

try

isnull([Actual Time of Arrival])

instead and see if that works

thanks

Joe

Re: expression does not work when indicating a field needs to be empty.

Tue, 08 Nov 2011 09:59:35 GMT

Hi stormy,

depending on your source you may have real null-values in your field [Actual Time of Arrival]. In this case the expression above won't work. Try this instead:

if( . . . IsNull([Actual Time of Arrival], . . .)

HtH

Roland

Soory, was a bit late. I agree with the post above.

expression does not work when indicating a field needs to be empty.

Tue, 08 Nov 2011 10:08:23 GMT

Thanks.

Works