Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, All
I have tried all known to me solutions to reflect 'Null' for all Null value.
As result worked only this: If(Len(Trim(city))=0,'Null',city) as city1
As you understand it's not the most elegant way. Maybe someone has penetrated this problem more deeply?
WHY?
I will be grateful for any comments and ideas!
Script code:
SET NullInterprete= 'Null';
SET NullDisplay= 'Null';
SET NullValue='Null';
NullAsValue city;
City:
LOAD
city,
If(Len(Trim(city))=0,'Null',city) as city1,
FROM
(txt, utf8, embedded labels, delimiter is ',', msq) ;
A quick try; spelling correction, remove extra 'e' may be.
SET NullInterpret= 'Null';
try this also
NULLASVALUE *;
Thanks! It did not help
did not help! Thanks
What are you exactly trying to achieve? 'Null' to be treated as real null() that should not appear in the listbox? I guess few of your null declarations are contradictory.
NullasValue:
Mapping Load
Null(), 'Null' AutoGenerate 1;
MAP City USING NullasValue;
You may try Map using statement
Pls, look at screenshot. City = City1 = 'Null'
Sorry, I see that too. But I don't see what is not there, i.e. - that you want it to be like.
Your value isn't NULL else it contained any not visible/printable chars or is just empty which means something like: = '' and which is not NULL and therefore all the NULL features from Qlik won't work. In your case it's quite obvious within in your listbox because you could select this value - NULL instead wouldn't be displayed there and is also in other objects like tables not selectable.
Therefore your solution is a good one and very common. An alternatively to this might be an mapping-approach like this one: Filling Default Values Using Mapping | Qlikview Cookbook.
- Marcus