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 · Accepted solution]

try if(isNull(B),'No Data','Data Available')

[gireesh1216]

Thanks

[its_anandrjs]

Try also

if( Len(B) = 0,'No Data','Data Available')

Regards

Anand

[gireesh1216]

Hi

I am trying to do not equal to 'null '.But condition not working

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

[Chanty4u]

try this

if('B'<>' ','null','data') as new

[its_anandrjs]

Try this also

if(isnull(B) = -1,'No Data','Data Available') as Status

Regards

Anand

[Anonymous]

Does this not solve your issue?

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

isNull(B) is a boolean and will return True or false. when evaluated.

Are you using it in script or in an expression?

[gireesh1216]

I am using in script level

[gireesh1216]

Your expression also working

BELOW EXPRESSION ALSO WORKING

If(B>0,'NO DATA','DATA')