topic Simple If Statement? in QlikView

Simple If Statement?

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

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

Re: Simple If Statement?

Anonymous — Mon, 14 Nov 2016 06:52:15 GMT

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

Re: Simple If Statement?

gireesh1216 — Mon, 14 Nov 2016 06:55:25 GMT

Thanks

Re: Simple If Statement?

its_anandrjs — Mon, 14 Nov 2016 07:03:37 GMT

Try also

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

Regards

Anand

Re: Simple If Statement?

gireesh1216 — Mon, 14 Nov 2016 07:05:56 GMT

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

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

Re: Simple If Statement?

Chanty4u — Mon, 14 Nov 2016 07:09:45 GMT

try this

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

Re: Simple If Statement?

its_anandrjs — Mon, 14 Nov 2016 07:14:29 GMT

Try this also

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

Regards

Anand

Re: Simple If Statement?

Anonymous — Mon, 14 Nov 2016 07:14:57 GMT

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?

Re: Simple If Statement?

gireesh1216 — Mon, 14 Nov 2016 07:15:59 GMT

I am using in script level

Re: Simple If Statement?

gireesh1216 — Mon, 14 Nov 2016 07:19:17 GMT

Your expression also working

BELOW EXPRESSION ALSO WORKING

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

Re: Simple If Statement?

Anonymous — Mon, 14 Nov 2016 07:19:47 GMT

Should work as is in script.

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

Re: Simple If Statement?

Chanty4u — Mon, 14 Nov 2016 07:22:26 GMT

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

];

Re: Simple If Statement?

gireesh1216 — Mon, 14 Nov 2016 07:25:46 GMT

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

Re: Simple If Statement?

gireesh1216 — Mon, 14 Nov 2016 07:26:51 GMT

thanks

Re: Simple If Statement?

its_anandrjs — Mon, 14 Nov 2016 07:28:56 GMT

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

Regards,

Anand

Re: Simple If Statement?

Chanty4u — Mon, 14 Nov 2016 07:31:09 GMT

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

];