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

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

Wed, 16 May 2012 12:45:13 GMT

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 — Wed, 16 May 2012 14:31:46 GMT

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

IAMDV — Wed, 16 May 2012 14:38:27 GMT

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

Cheers,

swuehl — Wed, 16 May 2012 15:05:59 GMT

Try

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

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

instead of

if( isnull(FIELD), ...