Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use below code
if(isnull(max(o.created_at))=-1,'null',max(o.created_at)) ) as last_order_date,
Hope this helps
If( Len( Trim( Field ) ) = 0, ...
is usually the best test. See more on http://community.qlik.com/docs/DOC-3155
HIC
Try: alt(max(o.created_at),'null') as last_order_date
use below code
if(isnull(max(o.created_at))=-1,'null',max(o.created_at)) ) as last_order_date,
Hope this helps
Hi,
Thanks.
Then I get that the "isnull" function requires 2 arguments?
/Julia