isnull/isempty?

[#1]

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]

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

is usually the best test. See more on http://community.qlik.com/docs/DOC-3155

HIC

[Gysbert_Wassenaar]

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

[SunilChauhan · Accepted solution]

use below code

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

Hope this helps

[#5]

Hi,

Thanks.

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

/Julia