topic Re: Null Issue in QlikView

Null Issue

aveeeeeee7en — Wed, 23 Apr 2014 16:51:06 GMT

Hi Community

I want to replace Null values by a word 'VACANT'

I have use isnull() but anyhow it is not working.

Regards

Aviral

Re: Null Issue

maxgro — Wed, 23 Apr 2014 16:55:19 GMT

replace

=if(isnull(reviewer),'VACANT',reviewer)

with

=if(len(trim(reviewer))=0,'VACANT',reviewer)

and other similar dimensions in the same way

Re: Null Issue

Wed, 23 Apr 2014 17:06:59 GMT

I don't see any nulls in the data on your dashboard, they appear to be showing as blank strings which is not the same thing as a NULL. I feel like QV is not recognizing these as nulls and that's why your expressions are not working.

Re: Null Issue

MK_QSL — Wed, 23 Apr 2014 17:13:01 GMT

=IF(Len(Trim(reviewer))=0,'VACANT',reviewer)

Re: Null Issue

Joseph_Musekura — Wed, 23 Apr 2014 17:22:29 GMT

Before using IsNull in “ if” statement, you should well test
the field reviewer and see if the value is NULL or not (see attached).

Thus I agreed with Christian you need to use another
expression and replace either NULL /MISSING value by VACANT

Re: Null Issue

dseelam — Wed, 23 Apr 2014 17:26:50 GMT

Hello Nag,

Try use this

if([field] < 0,Date([field]*-1),

if(isnull([field]),'VACANT', Date([field]))) AS [field],

Re: Null Issue

aveeeeeee7en — Wed, 23 Apr 2014 17:42:44 GMT

Thank You Massimo

Missed this thing.

Re: Null Issue

aveeeeeee7en — Wed, 23 Apr 2014 17:45:28 GMT

Thank You all.

I appreciate all of yours Efforts.

Thanks Again.