topic Re: If statment with IsNull in QlikView

If statment with IsNull

Tue, 19 Apr 2016 07:23:56 GMT

I'm trying a if statement with IsNull, and it does not seem to give med the correct output. I have tried the same statement as a expression after Load and it works perfect. Any Ideas how to get it working inside the script load?

My output becomes

Treatment Exists on all 'Treatment Exists' which is correct, but shows a null on 'No Treatments' i use this in the scrip load

if(IsNull(Treatment_ID),'No Treatment','Treatment exists') as Status

Thanks Theo

Re: If statment with IsNull

tamilarasu — Tue, 19 Apr 2016 07:27:25 GMT

Try,

if(Len(Trim(Treatment_ID))=0,'No Treatment','Treatment exists') as Status

Re: If statment with IsNull

Anonymous — Tue, 19 Apr 2016 07:29:23 GMT

Hi,

you can try:

if(IsNull(Treatment_ID) or Len(Trim(Treatment_ID))=0,'No Treatment','Treatment exists') as Status

Re: If statment with IsNull

Tue, 19 Apr 2016 07:34:17 GMT

Hi, sorry did not work because Treatment_ID that does not exist is not set to 0 its blank - thanks anyway

Re: If statment with IsNull

Tue, 19 Apr 2016 07:36:44 GMT

Hi, sorry did not work because Treatment_ID that does not exist is not set to 0 its blank - thanks anyway

Re: If statment with IsNull

tresB — Tue, 19 Apr 2016 07:39:43 GMT

Did you really try the expression suggested above? It is not really checking for it's value (to be 0) but it's length. Nulls are often confusing because there would be values with zero length or spaces which are not nulls. You can capture all these cases (including real nulls) with the above expression. If that is not working, try to share a sample qvw that demonstrates the issue.

Re: If statment with IsNull

kkkumar82 — Tue, 19 Apr 2016 07:49:27 GMT

Try in the edit

Set NULLINTERPRET ='';

Re: If statment with IsNull

kkkumar82 — Tue, 19 Apr 2016 07:49:45 GMT

After that your if condition