How to fill column with several conditions using QGIS field calculator?

Question

I know the synthax in order to fill one field with only one condition (field calculator):

---

case

When "attribut" = 'value' then value

End

---

But how to do populate automatically one field with two or three or more conditions?

I tried the following command but it does not work :

---

case

When "attribut" = 'value" and "attribut number2" = 'value' then value

End

---

Could you throw light for me?

Answer 1

Your values need to have single quotes around them, one has a double quote and one has no quotes (field names need double quotes and field values need single quotes):

This should work:

CASE

WHEN "attribut" = 'value' AND "attribut number2" = 'value' THEN 'value'

END