I would like to select objects from the attribute table based on multiple attributes.

I want to select all ojects that have 'ja' in the column "BLAUWBORST", all objects that have 'ja' in the column "BRUINE_KIE", objects that have 'ja' in both of them and objects that have 'ja' in the column 'veertien' or 'vijftien' or...

enter image description here

  • 1
    What expression have you tried? – BERA Mar 2 '18 at 8:26
  • "BLAUWBORST" = 'ja' or "BRUINE_KIE" = 'ja' or "veertien" = 'ja' or... But i realise that's wrong because then QGIS selects objects without looking at the BLAUWBORST or BRUINE_KIE and only to "veertien" – user115595 Mar 2 '18 at 8:44
  • so you want just those rows which have 'ja' in all the rows? – LaughU Mar 2 '18 at 8:45
  • No, rows that have 'ja' in BRUINE_KIE OR BLAUWBORST AND 'ja' in 'veertien' or 'vijftien' or 'zestien' – user115595 Mar 2 '18 at 8:51

Two options to archive this:

  1. Simply connect your selection statements with a logic operator "OR" is the one you are looking for. The result is something like:

    "BLAUWBORST" = 'ja' OR "BRUINE_KIE" = 'ja' OR ... 
  2. Use the Add to Selection button(image 1) when you write your selecting like this

    • "BLAUWBORST" = 'ja' -> Click "select"
    • "BRUINE_KIE" = 'ja' -> click on the arrow and click "Add to selection"

Image 1 where to click

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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