replace a null with comment

[rido1421]

load   *,         

       if(isnull(AGENTNAME),'***NO angent***',AGENTNAME) as "oAGENTNAME";

       //resident ICDPUB.T_UCP_STAFFWORKNO;

Hi

How do i replace a null value with a "comment".

i have tried the above :

this Qlikview does not see.

[schlettig]

Hi Ridhaa Hendricks,

if(isnull(AGENTNAME),'***NO angent***',AGENTNAME) as "oAGENTNAME";

       //resident ICDPUB.T_UCP_STAFFWORKNO;

it does not always work with isnull() i don't know why.

I use in these cases:

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

the performance is not the best, but in works in all cases.

the trim removes Whitespaces in a string, so it would also test a ' ' as Null, but you can lease this out, obviously.

Best regards,

Christian

[rido1421]

ta! Christian

i recieve : error in expression ")" expected,  for the life of me I can not make out where.

i placed it Immediately after , this did not work, i placed it after the rest of the script & still

[michael_maeuser]

if(len(trim((AGENTNAME)))=0,'***NO angent***',AGENTNAME)

[schlettig]

Hi,

try:

if(len(trim(AGENTNAME))>0,'***NO angent***',AGENTNAME) as "oAGENTNAME";

Best regards,

Christian

[#6]

Hi,

Please try like this

IF(IsNull(AGENTNAME) OR AGENTNAME=' ','Unknown',AGENTNAME) AS oAGENTNAME

[#7]

if( agentname = null(), 'whatever', agentname) as agentname

[rido1421]

thank you folk! thank you very much

solutions work!!!!