Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

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

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.

1 Solution

Accepted Solutions
Not applicable

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

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

3 Replies
Not applicable

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

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

Not applicable

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

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.

Not applicable

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

Thanks.

Works