topic Re: not Null and not Blank in QlikView

not Null and not Blank

alec1982 — Wed, 15 Apr 2015 20:20:24 GMT

hi all,

I have a column coming from a table with nothing on some rows.. I wasn't able to find out if the value is null, blank..or what is it.

I tried

if(len(trim(MyField))=0,1,0)

if(isnull(MyField)>0,1,0)

if(MyField=Null(),1,0)

if(MyField='' ,1,0)

if(MyField=' ' ,1,0)

none of the above gave me 1 as a result when trying to switch the value on the script side..

the following worked when trying to test through the UI if(MyField='' ,1,0) and returned 1 but i need it to work on the script..

Any idea on what is nothing could be?

Best,

Alec

Re: not Null and not Blank

maxgro — Wed, 15 Apr 2015 20:28:16 GMT

not len(trim(MyField))=0

Re: not Null and not Blank

sunny_talwar — Wed, 15 Apr 2015 20:29:08 GMT

This may still not work, but just curious if this helps:

if(Len(Trim(MyField))=0,1,0)

Best,

Sunny

Re: not Null and not Blank

sunny_talwar — Wed, 15 Apr 2015 20:30:15 GMT

=If(Len(Trim(MyField))=0,1,0)

Re: not Null and not Blank

alec1982 — Wed, 15 Apr 2015 20:37:56 GMT

That's what I used but it didnt work too..

Re: not Null and not Blank

sunny_talwar — Wed, 15 Apr 2015 20:38:59 GMT

Would you be able to share a sample?

Best,

Sunny

Re: not Null and not Blank

alec1982 — Wed, 15 Apr 2015 20:41:02 GMT

I am unable to share it..

Re: not Null and not Blank

sunny_talwar — Wed, 15 Apr 2015 20:44:04 GMT

Why not try them all at once?

If(Len(Trim(MyField)) = 0 or IsNull(MyField) or Trim(MyField) = '', 1, 0)

Sunny

Re: not Null and not Blank

alec1982 — Wed, 15 Apr 2015 20:44:31 GMT

Please find attached the qvw..

Re: not Null and not Blank

sunny_talwar — Wed, 15 Apr 2015 20:45:21 GMT

I don't see anything attached.

Re: not Null and not Blank

alec1982 — Wed, 15 Apr 2015 20:45:54 GMT

I did but it didn't work either.. I attached the qvw on the discussion on top

Re: not Null and not Blank

alec1982 — Wed, 15 Apr 2015 20:48:08 GMT

I found the issue........... it is a concatenate of two tables on my script and I was trying with the top part while the issue on the second part of the concatenation..

Re: not Null and not Blank

sunny_talwar — Wed, 15 Apr 2015 20:49:54 GMT

Hahahahaha

Glad you found the issue.

Best,

Sunny