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?


3 Answers 3


Use either

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


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

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


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".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.