topic Non Null Data showing as null in QlikView

Non Null Data showing as null

Fri, 15 Mar 2013 21:16:45 GMT

I am getting occasional null data displays in my straight table when the data is not null.

**NOTE: I have my properties set to "NNUU" being used for the null representation instead of "-"

Please see view below. To Try and identify I changed my load script to this:

if (IsNull("po_num"),'999','*' & "po_num" & '*') as po_num,

As you can see by the screen print, it is not showing as null, otherwise it would bring in 999 as a value, but yet it brings in my "NNUU" Null identifier. I have tried the LEN function to see if it was LEN("po_num") = 0 and it again passed that test....but displays the Null value.

This happens very sporadically which leads me to believe this are hidden/invisible characters at work here (which I was hoping to identify with the * symbols added.)

Any thoughts on this fluke?

Let me clarify: I am not trying to get the 999 statement above to work. I am trying to figure out why this field is getting the null representation shown "NNUU" when it has a valid and normal PO number in the database.

Re: Non Null Data showing as null

Fri, 15 Mar 2013 21:20:08 GMT

Hi,

try with this:

Text(if (IsNull("po_num"),'999','*' & "po_num" & '*')) as po_num,

if (IsNull("po_num"), Text('999'), Text('*' & "po_num" & '*')) as po_num,

Regards,

Ricardo

Re: Non Null Data showing as null

Fri, 15 Mar 2013 21:30:06 GMT

You said:

"Let me clarify: I am not trying to get the 999 statement above to work. I am trying to figure out why this field is getting the null representation shown "NNUU" when it has a valid and normal PO number in the database."

Probably this po_num field has two o more values (two o more rows), so they can't show it in a row (Straight table). First, Did you count the values exists by po_num?

Ricardo

Re: Non Null Data showing as null

Fri, 15 Mar 2013 21:42:03 GMT

That was the push I needed. I have multiple PO's with the exact same line items....Thanks for spark!

Re: Non Null Data showing as null

Fri, 15 Mar 2013 21:43:10 GMT

Glad I could help (: