Simple If Statement?

[gireesh1216]

Hi All,

I am trying to use simple if statement if(B=' ','No Data','Data Available').But IF statement not working in qlikview.

[Anonymous]

Should work as is in script.

if(isNull(B),'No Data','Data Available') As DataFlag

[Chanty4u]

try this may be

aa:

LOAD *,

if(B>0,'No Data','Data Available') as Status;

LOAD * Inline [

A,B

aa,bb

cc,dd

dd,

rr,

ef,gg

mm,

rm,rw

];

[gireesh1216]

Hi

your expression is working good.But i want not equal to null

i tried below script but not working

if(isnull(B) <> ' ','No Data','Data Available') as Status

[gireesh1216]

thanks

[its_anandrjs]

Isnull function is returning -1  if there is NULL and 0 if there is any value.

Regards,

Anand

[Chanty4u]

hi,

am not sure check below

aa:

LOAD *,

If(Len(B)=0,'Null','data')     AS status;

LOAD * Inline [

A,B

aa,bb

cc,dd

dd,

rr,

ef,gg

mm,

rm,rw

];