Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

zagzebski
Not applicable

Giving null values a <Null> value

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

Tags (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Giving null values a <Null> value

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


talk is cheap, supply exceeds demand
7 Replies
alexandros17
Not applicable

Re: Giving null values a <Null> value

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
Not applicable

Re: Giving null values a <Null> value

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

Gysbert_Wassenaar
Not applicable

Re: Giving null values a <Null> value

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


talk is cheap, supply exceeds demand
sinanozdemir
Not applicable

Re: Giving null values a <Null> value

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

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

zagzebski
Not applicable

Re: Giving null values a <Null> value

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
Not applicable

Re: Giving null values a <Null> value

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.


talk is cheap, supply exceeds demand
zagzebski
Not applicable

Re: Giving null values a <Null> value

awesome. and simple.

Thanks!