[Qgis-user] Multy field labels

[Irakli Ugulava]

Thanks a lot,

I combine both advises, and get at last this

CASE WHEN "NAME_GEO" IS NOT NULL THEN CONCAT ("NAME_GEO", "ELEV") ELSE
"ELEV" END

it works at last

Thanks a lot :)



On Fri, May 15, 2015 at 6:29 PM, Andreas Neumann <a.neumann at carto.net>
wrote:

>  Hi,
>
> You need to use COALESCE(labelfield,'alternate text')
>
> If the label contains data, the data is used, if it contains NULL, the
> alternate text is displayed, which often is an empty string, a replacement
> text or another field.
>
> In your case, you could use:
>
> COALESCE("NAME_GEO" || '(' || elev || ')','elev')
>
> In case it has a name, the name is displayed with elevation, if it is
> null, then the elevation is displayed.
>
> This is the same syntax like SQL is using.
>
> Hope this helps,
> Andreas
>
>
> On 15.05.2015 16:01, Irakli Ugulava wrote:
>
> For physical map need to label summits and elevation points, some of them
> have name some no, so I need to label them from different fields.
>
>  when I use expression :
>
>  "NAME_GEO"   ||  "elev"
>
>  It works, but summits with no names, (field "NAME_GEO" is empty), has no
> label at all, according to ArcGis logic they should have only elevation on
> labels.
>
>  I try following expression
> CASE WHEN "name_geo" is null   THEN "NAME_GEO"   ||   "ELEV"  ELSE "elev"
>
>  but it return no labels at all.
>
>  Thanks All
>
>  --
> Irakli Ugulava
> Senior GIS Expert, Cofounder
> GeoLand Ltd.
> 3 Telegraph Cule-de-sac
> Tbilisi 0105, Georgia,
> Tel:  +995 32 922553
> Mob +995 99 172016
>
>
>
> _______________________________________________
> Qgis-user mailing listQgis-user at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
Irakli Ugulava
Senior GIS Expert, Cofounder
GeoLand Ltd.
3 Telegraph Cule-de-sac
Tbilisi 0105, Georgia,
Tel:  +995 32 922553
Mob +995 99 172016
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150515/289871e1/attachment.html>