Filtering data with NULL in QGIS

Asked Nov 07 '19 at 07:26

Active Nov 07 '19 at 07:26

Viewed 52 times

Working with QGIS Zanzibar. I have a data set where many values are NULL (or blank), I wish to filter the data to show only those with NULL. In the query builder I use "FieldName" = NULL, but this removes ALL the data... Why. The data I'm trying to filter on is a date.

asked Nov 07 '19 at 07:26

user131678

1

There is a small trick "FieldName" IS NULL – Taras Nov 07 '19 at 07:37
Many thanks.. I knew there was a trick to solve this one. – user131678 Nov 07 '19 at 07:43
And the inverse then is "FieldName" IS NOT NULL. It's because NULL is a state not a value. – TeddyTedTed Nov 07 '19 at 09:15
Just like Excel.. it too can't handle NULL/Blank very well.. Thanks for the tip "NULL is a state not a value" – user131678 Nov 08 '19 at 09:37

Filtering data with NULL in QGIS

0 Answers0