Showing Null Values on a Map
When creating a thematic map which accumulates data from a lower level of geography, if that data contains a null, it will by default not appear on the map. Using the VALUE_OF function treats nulls as 0 and therefore allows areas with ‘incomplete’ data to be represented.
When creating your Thematic Classifier expression, navigate through links down to the geographical level at which the data is held.
Double click on the column you wish to display to add it to the expression box
Add the VALUE_OF(*) function around the current expression
Example
VALUE_OF(SCHEMA_GROUP:(SCHEMA.COLUMN))
Complete the remainder of the wizard as usual
Last updated