Symbology by Expression

DavidPaul

I need to symbolize a layer based on the presents or absents of data.

The layer has a text field that has some of the rows populated and some not.

The fill of the symbol that is related to that column in the table needs to be:
RED if the row IS NOT null
WHITE if the row IS null

Is there a way to do this without creating a calculated field?

Dave

RichardFairhurst

I need to symbolize a layer based on the presents or absents of data.

The layer has a text field that has some of the rows populated and some not.

The fill of the symbol that is related to that column in the table needs to be:
RED if the row IS NOT null
WHITE if the row IS null

Is there a way to do this without creating a calculated field?

Dave

You use a Categorized symbol layer.  Just add the Null value category only and assign it a color of WHITE (optionally group it with whitespace values such as "" or " " if you like).  Then enable the "All Other Values" symbol and make its symbol RED.  Now the layer will color any and all values that are not null as Red regardless of how ever many values your layer may have as well as any future values that may currently be unknown.  If you click the "Count" column heading at the right hand side of the symbol area, you can get a count of how many features fall in each of the two groups.  The layer will respond instantly to any changes in the field, unlike a calculated value based on the field.