Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share the script? Difficult to suggest anything before looking at the script
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)
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
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
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
As i say it does not come from the DB