topic Null value check doesn't work in QlikView

Null value check doesn't work

harleen_singh — Thu, 05 Jul 2012 05:59:49 GMT

Hello,

I am using following statement in backend to check and fill null values with 1 but it is not working

if(IsNull([Unit of Measure Code]),1,0) as ABC,

What may be the problem??

thanks
Lavi

deepakk — Thu, 05 Jul 2012 06:02:20 GMT

hi,

Try this code

if(IsNull([Unit of Measure Code])=-1 ,1,0) as ABC,

If(len(trim(([Unit of Measure Code])) =0,1,0) as ABC

Deepak

harleen_singh — Thu, 05 Jul 2012 06:20:40 GMT

@deepak,

both statements not working

thanks

Lavi

deepakk — Thu, 05 Jul 2012 06:29:42 GMT

HI Lavi,

Can you attach any sample data. I can check at my end. Either of the above code should work or there might not be any null or blank data .

Deepak