• Blog posts

    Bio

    by David Crowther

    Qgis_null_values_DC_01.png

    Question:

    Is it possible to change the value being shown in the Attribute Table when there are blank/null values?

    Answer:

    By default, when you browse an Attribute Table for a Layer in QGIS and there are blank values for data the cell will show a NULL value.

    Qgis_null_values_DC_02.jpg

    However, choosing Settings > Options > on the Data Sources Tab > and the Feature Attributes and Table section you can change the default value that is used for blank/null values. Here we have set the value to say – No Data Entered.

    Qgis_null_values_DC_03.jpg

    From now, when you open an Attribute Table for a Layer any cells that have Null/Blank values will now show - No Data Entered.

    Qgis_null_values_DC_04.jpg