topic isnull/isempty? in QlikView

isnull/isempty?

Thu, 07 Feb 2013 14:15:46 GMT

Hi,

I want to check if a field is empty.

How do I do?

I want to use below case

case when (isempty(max(o.created_at)),'null',max(o.created_at)) as last_order_date,

If the field max(o.created_at) is empty, then I want to add the text "null" otherwise the date schould be shown.

/Julia

hic — Thu, 07 Feb 2013 14:23:12 GMT

If( Len( Trim( Field ) ) = 0, ...

HIC

Gysbert_Wassenaar — Thu, 07 Feb 2013 14:24:02 GMT

Try: alt(max(o.created_at),'null') as last_order_date

SunilChauhan — Thu, 07 Feb 2013 14:30:02 GMT

use below code

if(isnull(max(o.created_at))=-1,'null',max(o.created_at)) ) as last_order_date,

Hope this helps

Thu, 07 Feb 2013 14:38:49 GMT

Hi,

Thanks.

Then I get that the "isnull" function requires 2 arguments?

/Julia