topic Re: replace a null with comment in QlikView

replace a null with comment

rido1421 — Thu, 12 Sep 2013 09:01:26 GMT

load   *,

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

       //resident ICDPUB.T_UCP_STAFFWORKNO;

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

i have tried the above :

this Qlikview does not see.

schlettig — Thu, 12 Sep 2013 09:06:06 GMT

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 — Thu, 12 Sep 2013 09:52:50 GMT

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 — Thu, 12 Sep 2013 09:55:34 GMT

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

schlettig — Thu, 12 Sep 2013 09:56:10 GMT

Hi,

try:

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

Best regards,

Christian

Thu, 12 Sep 2013 10:04:01 GMT

Hi,

Please try like this

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

Thu, 12 Sep 2013 10:09:27 GMT

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

rido1421 — Thu, 12 Sep 2013 11:10:47 GMT

thank you folk! thank you very much

solutions work!!!!