topic Re: Nulls or Space or ?? in QlikView

Nulls or Space or ??

tmumaw — Tue, 05 Dec 2017 13:51:29 GMT

I have a field that I have tried

if(Len(Trim(ZZCANCEL_STATUS] > 0),1,0) as Can_SW

If(IsNull([ZZCANCEL_STATUS]) ,0,1) as Can_SW

Neither one works any ideas?

Thanks

avinashelite — Tue, 05 Dec 2017 13:52:48 GMT

try like this

if( Len(Trim (ZZCANCEL_STATUS ) ) > 0,1,0) as Can_SW

Anil_Babu_Samineni — Tue, 05 Dec 2017 13:53:18 GMT

First one should be this? And second one okay to me

if(Len(Trim([ZZCANCEL_STATUS])) > 0,1,0) as Can_SW

its_anandrjs — Tue, 05 Dec 2017 13:55:21 GMT

This way try

if( Len( Trim(ZZCANCEL_STATUS]) > 0,1,0) as Can_SW

If( IsNull ( [ZZCANCEL_STATUS]) = -1 ,1,0) as Can_SW

sunny_talwar — Tue, 05 Dec 2017 13:56:10 GMT

May be this

If(Len(Trim(PurgeChar(ZZCANCEL_STATUS, chr(32) & chr(160)))) > 0, 1, 0) as Can_SW

tmumaw — Tue, 05 Dec 2017 14:17:32 GMT

Thanks worked perfectly