Field looks like it is blank but isnull function does not work

[#1]

dear QV users,

I would like to use the isnull function for a field, but the field looks like it's blank, but isn't.

Are there other functions to solve this?

With kind regards,

Aissam

[Anonymous]

If isnull() doesn't work, you can try trim(field)=''
This will test for blank fields.
-Phil

[IAMDV]

Aissam - You can also use IsText() and IsNum() boolean functions to evaluate the field value. Does it show the '-' in the field value?

Cheers,

DV

www.QlikShare.com

[swuehl · Accepted solution]

Try

if( len(trim(FIELD))=0, ..

or

if( len(trim(purgechar(FIELD, chr(160)))) = 0,...

instead of

if( isnull(FIELD), ...

http://community.qlik.com/message/182388