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
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
And then, nulls won't be rendered.
If you go to the layer properties label tab, select the Method drop down that says:
you will see a box appear reading "SQL Query..."
If you then enter:
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.