Discussion Board for collaboration related to QlikView App Development.
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.
Go to Solution.
[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,
isnull([Actual Time of Arrival])
instead and see if that works
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], . . .)
Soory, was a bit late. I agree with the post above.