topic Re: replacing blank value with string in QlikView

replacing blank value with string

Wed, 08 Oct 2014 15:54:59 GMT

hi QV,

how do we handle blank values in Qv,

I have a field like DEL_BLOCK,some of that fields records coming as blank from DB.so I want to assign a string for blank values.

looks below is the cond i have used,is it fine??

If(IsNull([DEL_BLOCK]=' '),'Free','Blocked') as Blocked

Thanks

Anonymous — Wed, 08 Oct 2014 15:59:29 GMT

try with

If(len([DEL_BLOCK])=0,'Free','Blocked') as Blocked

Marc.

Clever_Anjos — Wed, 08 Oct 2014 16:18:55 GMT

Please use TRIM, since you could have spaces into your field

If(len(trim([DEL_BLOCK]))=0,'Free','Blocked') as Blocked

JonnyPoole — Wed, 08 Oct 2014 20:33:28 GMT

NULL is different to blank. Its a long story...

NULL:

If(IsNull([DEL_BLOCK]),'Free','Blocked') as Blocked

Blank:

If([DEL_BLOCK]='','Free','Blocked') as Blocked

or like clever said

If( trim([DEL_BLOCK])='','Free','Blocked') as Blocked

or like marc said

If(len([DEL_BLOCK])=0,'Free','Blocked') as Blocked

Anonymous — Wed, 08 Oct 2014 22:13:29 GMT

If(IsNull([DEL_BLOCK]),'Free','Blocked') as Blocked