It works for conditional styles also, but just with: Z_msnm % 200 = 0
Thank you again, and sorry for my poor knowledge of SQL Carlos 2013/8/15 Carlos Cerdán <[email protected]> > Issue solved, It works!. > > Thank you Nathan and Jonathan. The Modulo operator is new for me. > > Regards > > Carlos > > > > > 2013/8/15 Jonathan Moules <[email protected]> > >> Exactly what I was thinking, though wouldn't you want the modulo to be >> 200 in this case (you used 400 in your example)? >> Carlos - the advantage of this is it will automagically work for all >> heights, even mount Everest or the Mariana Trench. >> >> Cheers, >> Jonathan >> >> >> >> >> On 15 August 2013 15:08, Nathan Woodrow <[email protected]> wrote: >> >>> or you can use the Modulo operator ;) >>> >>> CASE WHEN Z_msnm % 400 = 0 THEN Z_msnm END >>> >>> - Nathan >>> >>> >>> On Fri, Aug 16, 2013 at 12:04 AM, Carlos Cerdán <[email protected]>wrote: >>> >>>> Hi dear group >>>> >>>> I have a topographic layer that I want to put labels when the contour >>>> is multiplo of 200. I got it with this large conditional sentence: >>>> >>>> case >>>> >>>> when ("Z_msnm" =200 OR "Z_msnm" =400 OR "Z_msnm" =600 OR "Z_msnm" =800 >>>> OR "Z_msnm" =1000 OR "Z_msnm" =1200 OR "Z_msnm" =1400 OR "Z_msnm" =1600 OR >>>> "Z_msnm" =1800 OR "Z_msnm" =2000 OR "Z_msnm" =2200 OR "Z_msnm" =2400 OR >>>> "Z_msnm" =2600 OR "Z_msnm" =2800 OR "Z_msnm" =3000 OR "Z_msnm" =3200 OR >>>> "Z_msnm" =3400 OR "Z_msnm" =3600 OR "Z_msnm" =3800 OR "Z_msnm" =4000 OR >>>> "Z_msnm" =4200 OR "Z_msnm" =4400 OR "Z_msnm" =4600 OR "Z_msnm" =4800 OR >>>> "Z_msnm" =5000 OR "Z_msnm" =5200 OR "Z_msnm" =5400 OR "Z_msnm" =5600 OR >>>> "Z_msnm" =5800 OR "Z_msnm" =6000 OR "Z_msnm" =6200 OR "Z_msnm" =6400 OR >>>> "Z_msnm" =6600 OR "Z_msnm" =6800) then "Z_msnm" >>>> >>>> end >>>> >>>> After to do this condition all was ok, but an issue appear: the "label >>>> layer configuration window" tries to show the condition in one line only, >>>> so the width of this window is so long that the right part of this window >>>> goes out of monitor visible area. >>>> >>>> Is there some way to avoid this?. It happens even if each condition is >>>> in diferent lines (QGIS 1.8 on Ubuntu 12.04 and Windows 7). >>>> >>>> Is there another smaller condition to use instead that the one I made? >>>> >>>> Thank you in advance for any help >>>> >>>> ------ 8< --- Spanish version --- >>>> >>>> Hola estimado grupo: >>>> >>>> Tengo una capa topográfica a la cual deseo colocar etiquetas en las >>>> curvas de nivel múltiplo de 200. Esto lo hice con la condición mostrada >>>> arriba. >>>> >>>> case >>>> when ("Z_msnm ... etc >>>> end >>>> >>>> La condición trabaja bien, pero aparece un problema: la ventana de >>>> "configuración del etiquetado de la capa" muestra la condición en una sola >>>> línea, así que el ancho es tan grande que la parte derecha de esta ventana >>>> sale fuera del área visible del monitor. >>>> >>>> ¿Existe alguna manera de evitar esto? Esto sucede inclusive si cada >>>> condición está en una línea diferente ( QGIS 1.8 en Ubuntu 12.04 y Windows >>>> 7). >>>> >>>> ¿Hay alguna condición más corta que podría utilizar en lugar de la que >>>> hice? >>>> >>>> Gracias de antemano por cualquier ayuda >>>> >>>> ------ 8< ------- >>>> >>>> Carlos Cerdán >>>> >>>> _______________________________________________ >>>> Qgis-user mailing list >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>>> >>>> >>> >>> _______________________________________________ >>> Qgis-user mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >>> >> >> This transmission is intended for the named addressee(s) only and may >> contain sensitive or protectively marked material up to RESTRICTED and >> should be handled accordingly. Unless you are the named addressee (or >> authorised to receive it for the addressee) you may not copy or use it, or >> disclose it to anyone else. If you have received this transmission in error >> please notify the sender immediately. All email traffic sent to or from us, >> including without limitation all GCSX traffic, may be subject to recording >> and/or monitoring in accordance with relevant legislation. > > >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
