Giving null values a <Null> value

[zagzebski]

I have seen posts that state if you want to eliminate the unselectedable null " - " values in your data that you can add the following in the script before your load scripts:

NULLASVALUE *;
SET NullValue ='<NULL>';

Is this all that has to be done? I still get " - " values in my data. I am sure I must be over simplifying

Steve

[alexandros17]

I think this istructions works for the data loaded, if two or more tables are associated and there are null associations then you will see '-'

[sinanozdemir]

Then you must have blank values in your dataset as well as NULL values.

[Gysbert_Wassenaar · Accepted solution]

You may have missing values too. The difference between Null values and Missing values is explained in this document: NULL handling in QlikView

[sinanozdemir]

In this case, the below syntax should work for all NULL, blank and missing values:

Sum({<Dimension = {"*"}>}value)

[zagzebski]

Gysbert -

I doubt there is anything that can be done about this but was wondering...

When there is a missing value for example:  showing revenue by client but there is $1,000 attributed to missing (no client). Is there anyway to make this a selectable value? There are many times we want to research what data is at this intersection but it is a pain because you can't drill into those missing values.

Or maybe a different technique?

Steve

[Gysbert_Wassenaar]

What you can do is first select all clients. Next select the excluded values in another revenue related field that you know has no missing values (order id perhaps). What you end up with is a selection of the records that have no client.

[zagzebski]

awesome. and simple.

Thanks!