I have polygon layer in spatialite base, I need to have a label
combined from few fields, I use:
coalesce("SITE_TYPE_CD") || coalesce("MOISTURY_CD") ||
coalesce("STAN_SIEDLISKA_KOD") || coalesce("TD") || '\n' ||
coalesce("SOIL_SUBTYPE_CD") || coalesce("GLEBA_ODM1") || '-' ||
coalesce("STOP_WODY") || '-' || coalesce("SOIL_SPECIES_1_CD") ||
coalesce("SOIL_LEVEL_1_CD") || coalesce("SOIL_SPECIES_2_CD") ||
coalesce("SOIL_LEVEL_2_CD") || coalesce("SOIL_SPECIES_3_CD")
When there is no "coalesce" function, the label doesn't show (most of
the fields has NULL value, as I edit that layer all the time -> labels
show me which features were "filled" with true values).
I found the solution (about "coalesce" function) here:
http://gis.stackexchange.com/questions/122199/how-to-display-multiple-fields-as-labels-if-one-field-is-null
--- Treść przekazanej wiadomości ---
Temat: [Qgis-user] Multy field labels
Data: Fri, 15 May 2015 18:01:16 +0400
Nadawca: Irakli Ugulava <[email protected]>
Adresat: [email protected]
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 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
