Filtering which points to display using expressions in QGIS

Question

I have a load of points loaded in as a CSV file. I want to show only certain points based on their name, e.g. only value1, value4 and value8, the field name is "Drilled ID".

I have gone to symbology, then categorised and tried this:

"Drilled ID" = 'value1' or 'value4' or 'value8'

Then hit classify, but it doesn't display value1, value4 and value8 only.

Any ideas?

Answer 1

Use either

"Drilled ID" in ('value1','value4','value8')

Or

"Drilled ID" = 'value1' or "Drilled ID" = 'value4' or "Drilled ID" = 'value8'

Answer 2

Switch to Rule-based and use "Drilled ID" IN ('value1', 'value4','value8')

Consider setting a filter if you don't want to display anything else.

enter image description here

Answer 3

Instead of symbology, use Provider Feature filter: open layer properties > Source > Query Builder and add this query:

"Drilled ID" IN ('value1', 'value4', 'value8')

Be aware that your field name contains a space. That might cause problems with CSV. Better stick to field names like "DrilledID" or "Drilled_ID".