Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I turn off labels that have null values?

I am using a leader with this label but I want it turned off if the values are null

share|improve this question

you can add a query filter to which labels will be rendered.

Check the section "Controlling which features are labelled".

Essentially, you will add a query to the label manager, something like this

[Attribute_being_labbeled] is not null

And then, nulls won't be rendered.

share|improve this answer

If you go to the layer properties label tab, select the Method drop down that says:

define classes of features and label classes differently

you will see a box appear reading "SQL Query..."

If you then enter:

 "Field of your choice" <> 'Unique value of your choice'

So, say the field is ROAD NAME and the unique road name you do not want to be visible is NULL

You will enter:


Same thing as the former example, but redundancy sometimes helps. That will to it.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.