<html>

  <head>

    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">

  </head>

  <body bgcolor="#FFFFFF" text="#000000">

     I have polygon layer in spatialite base, I need to have a label

    combined from few fields, I use:<br>

    <br>

    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")<br>

    <br>

    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).<br>

    <br>

    I found the solution (about "coalesce" function) here:<br>

<a class="moz-txt-link-freetext" href="http://gis.stackexchange.com/questions/122199/how-to-display-multiple-fields-as-labels-if-one-field-is-null">http://gis.stackexchange.com/questions/122199/how-to-display-multiple-fields-as-labels-if-one-field-is-null</a><br>

    <div class="moz-forward-container"><br>

      --- Treść przekazanej wiadomości ---

      <table class="moz-email-headers-table" border="0" cellpadding="0"

        cellspacing="0">

        <tbody>

          <tr>

            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">Temat: </th>

            <td>[Qgis-user] Multy field labels</td>

          </tr>

          <tr>

            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">Data: </th>

            <td>Fri, 15 May 2015 18:01:16 +0400</td>

          </tr>

          <tr>

            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">Nadawca:

            </th>

            <td>Irakli Ugulava <a class="moz-txt-link-rfc2396E" href="mailto:i.ugulava@gmail.com"><i.ugulava@gmail.com></a></td>

          </tr>

          <tr>

            <th align="RIGHT" nowrap="nowrap" valign="BASELINE">Adresat:

            </th>

            <td><a class="moz-txt-link-abbreviated" href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a></td>

          </tr>

        </tbody>

      </table>

      <br>

      <br>

      <div dir="ltr">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.

        <div><br>

        </div>

        <div>when I use expression :</div>

        <div><br>

        </div>

        <div>"NAME_GEO" Â  || Â "elev"</div>

        <div><br>

        </div>

        <div>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.</div>

        <div><br>

        </div>

        <div>I try following expressionÂ Â </div>

        <div>CASE WHEN "name_geo" is null Â  THEN "NAME_GEO" Â  || Â 

          "ELEV" Â ELSE "elev"</div>

        <div><br>

        </div>

        <div>but it return no labels at all.</div>

        <div><br>

        </div>

        <div>Thanks All<br clear="all">

          <div><br>

          </div>

          -- <br>

          <div class="gmail_signature">Irakli Ugulava

            <div>Senior GIS Expert, CofounderÂ <br>

              <div>GeoLand Ltd.</div>

              <div>3Â Telegraph Cule-de-sac</div>

              <div>Tbilisi 0105, Georgia,Â </div>

              <div>Tel: Â +995 32 922553</div>

              <div>Mob +995 99 172016</div>

              <div><br>

              </div>

            </div>

          </div>

        </div>

      </div>

      <br>

    </div>

    <br>

  </body>

</html>