I would like to select features using an expression. I have one field with +-100 different values. I would like to select all values except for two. Something like this: "FIELD" is NOT ( 'Value1', 'Value2' ), which would then select values 3 up to 98. However, this is all string text, not numbers 1 up to 100.

Any idea how to do this?

  • 2
    Im not an expert, but something like "FIELD IS NOT value1 AND FIELD IS NOT value2" wouldn't work?
    – Opazo
    Apr 19, 2022 at 14:03
  • that actually worked, thanks! Stupid i didn't think about it!
    – Nindooo
    Apr 19, 2022 at 14:08
  • Another possibility is to select those you don't want: FIELD = value1 or FIELD = value2. When selected, click the icon for invert selection, see: gis.stackexchange.com/a/239184/88814
    – Babel
    Apr 20, 2022 at 8:56
  • Ohh that is a nice one. I never noticed that icon before!
    – Nindooo
    Apr 20, 2022 at 21:03

1 Answer 1

"Field" not in ('Value 1', 'Value 2')

This should work for you.

  • Thanks that also works!
    – Nindooo
    Apr 20, 2022 at 8:32

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.