Null Data

[Anonymous]

Hello,

i have data that i reload from odbc Sql Server it come whit no null value.

But when i combine this field whit other that dont have relationship i get null(s) value.

My client want to select not only what he have he want also what he dont have.

e.g Show me all the Charge Amount That dont have Vessel_nm .

I read the article of " NULL handling in QlikView" and i need your help

[sunny_talwar]

Can you share the script? Difficult to suggest anything before looking at the script

[Chanty4u]

hi,

The nulls cmg frm ur DB  then try this in script.

SET NullValue = ' ';

NullAsValue *;  // You can give the listed field names instead of * (All fields)

[marcus_sommer]

NULL isn't selectable therefore you need to replace NULL with real values like 'NULL', 'MISSING' or '#NV'. A very good explanation and different methods to handle the various types of NULL could you find here: NULL handling in QlikView.

- Marcus

[Anonymous · Accepted solution]

Hi,

Have a look

Re: Null Values

Hope it helps!!

[santhosh_k_n]

Hi Ben,

Handle the null in the script as below

if(isnull(Vessel_nm) or Vessel_nm='' , 'Null',Vessel_nm) as Vessel_nm

hope this helps.

Regards,

SK

[swuehl]

You should be able to filter your data with set analysis and e() function used in a set modifier on an appropriate key field,

like attached sample.

See also

Excluding values in Set Analysis

[Anonymous]

As i say it does not come from the DB