Null Issue

[aveeeeeee7en]

Hi Community

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

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

Regards

Aviral

[maxgro · Accepted solution]

replace

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

with

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

and other similar dimensions in the same way

[#3]

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.

[MK_QSL]

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

[Joseph_Musekura]

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

[dseelam]

Hello Nag,

Try use this

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

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

[aveeeeeee7en]

Thank You Massimo

Missed this thing.

[aveeeeeee7en]

Thank You all.

I appreciate all of yours Efforts.

Thanks Again.