Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please use TRIM, since you could have spaces into your field
If(len(trim([DEL_BLOCK]))=0,'Free','Blocked') as Blocked
try with
If(len([DEL_BLOCK])=0,'Free','Blocked') as Blocked
Marc.
Please use TRIM, since you could have spaces into your field
If(len(trim([DEL_BLOCK]))=0,'Free','Blocked') as Blocked
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
If(IsNull([DEL_BLOCK]),'Free','Blocked') as Blocked