Discussion Board for collaboration on QlikView Scripting.
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:
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
Solved! Go to Solution.
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?
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.