topic Re: Giving null values a <Null> value in QlikView

Giving null values a value

zagzebski — Wed, 15 Jul 2015 13:39:30 GMT

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

Re: Giving null values a value

alexandros17 — Wed, 15 Jul 2015 13:46:53 GMT

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 '-'

Re: Giving null values a value

sinanozdemir — Wed, 15 Jul 2015 13:47:13 GMT

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

Re: Giving null values a value

Gysbert_Wassenaar — Wed, 15 Jul 2015 13:54:17 GMT

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

Re: Giving null values a value

sinanozdemir — Wed, 15 Jul 2015 13:58:14 GMT

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

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

Re: Giving null values a value

zagzebski — Thu, 16 Jul 2015 17:07:42 GMT

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

Re: Giving null values a value

Gysbert_Wassenaar — Thu, 16 Jul 2015 17:21:10 GMT

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.

Re: Giving null values a value

zagzebski — Thu, 16 Jul 2015 17:37:58 GMT

awesome. and simple.

Thanks!