[Qgis-user] Case

[Renato Saboya]

Eddison, try this:

CASE
  WHEN ( "W_BRILLO"  = 3 AND "W_PPT" =1 AND "W_TEMP"=2) THEN 2
  WHEN ("W_BRILLO"  = 2 AND "W_PPT" =2 AND "W_TEMP"=3) THEN 2
  WHEN ("W_BRILLO"  = 1 AND "W_PPT" =2 AND "W_TEMP"=3) THEN 3
  ELSE 5
END

Note, however, that you don't have any of these combinations in your table,
so you will get only null values. I put the "ELSE 5" there just so you know
the code is working.

Also, bear in mind that the lines inside CASE and END must be indented by
two spaces.

Cheers,

*Renato*


On Thu, 23 Aug 2018 at 18:05, Eddison Araya <eddisonjose at gmail.com> wrote:

> Hello, greetings, a question:
>
> [image: image.png]
>
> If I have that map:  *https://www.dropbox.com/s/6hvnrb37fvc00wl/ejemplo.zip?dl=0
> <https://www.dropbox.com/s/6hvnrb37fvc00wl/ejemplo.zip?dl=0> *
>
> E eu quero dizer:
>  Se W_BRILLO is equal to 3, se W_PPT is equal to 1, se W_TEMP is equal to
> 2, have a value of  2
>
> Se W_BRILLO   is equal to    2, se W_PPT  is equal to    2, se W_TEMP is
> equal to   3, have a value of 2
>
> Se W_BRILLO  is equal to    1, se W_PPT  is equal to    2, se W_TEMP  is
> equal to    3, have a value of 3
>
> I put this:
>
> CASE
>
> WHEN "W_BRILLO" = '3', "W_PPT" ='1', "W_TEMP" = '2' THEN 2
> WHEN "W_BRILLO" = '2', "W_PPT" ='2', "W_TEMP" = '3' THEN 2
> WHEN W_BRILLOI = '1', "W_PPT" ='2', "W_TEMP" = '3' THEN  3
>
>  END
>
>
> But I get an error!
>
> Thank you
>
> Eddison
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180823/8d4239d4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 7944 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180823/8d4239d4/attachment.png>