[Qgis-user] Field calculator : How to fill column with several conditions?

[Torsten Lange]

This worked for my test example:
CASE
WHEN "ID" = 10
and "test" = 100 THEN 500
END

Torsten

 Am 06-Feb-2015 21:49:34 +0100 schrieb lcelati at cci-paris-idf.fr: 
Dear all,

 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?

 --
 View this message in context: http://osgeo-org.1560.x6.nabble.com/Field-calculator-How-to-fill-column-with-several-conditions-tp5186069.html
 Sent from the Quantum GIS - User mailing list archive at Nabble.com.
 _______________________________________________
 Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150206/81dd18c6/attachment.html>