topic Null Data in QlikView

Null Data

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

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

Re: Null Data

sunny_talwar — Wed, 13 Apr 2016 11:09:49 GMT

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

Re: Null Data

Chanty4u — Wed, 13 Apr 2016 11:34:36 GMT

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)

Re: Null Data

marcus_sommer — Wed, 13 Apr 2016 13:36:21 GMT

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

Re: Null Data

Anonymous — Wed, 13 Apr 2016 13:47:02 GMT

Hi,

Have a look

Re: Null Values

Hope it helps!!

Re: Null Data

santhosh_k_n — Wed, 13 Apr 2016 13:51:33 GMT

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,

Re: Null Data

swuehl — Wed, 13 Apr 2016 13:55:31 GMT

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.

Re: Null Data

Anonymous — Thu, 14 Apr 2016 06:28:25 GMT

As i say it does not come from the DB