<p dir="ltr">Sorry that was Regis and Delaz</p>
<div class="gmail_extra"><br><div class="gmail_quote">On 22 Dec 2016 17:19, "damien stephens" <<a href="/user/SendEmail.jtp?type=node&node=5301028&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type="attribution"><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Thanks very much Regis and Relaz.<br>
Much appreciated.<br>
</p>
<div class="gmail_extra"><br><div class="gmail_quote">On 21 Dec 2016 16:08, "Régis Haubourg [via OSGeo.org]" <<a href="/user/SendEmail.jtp?type=node&node=5301028&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type="attribution"><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi, <div>you are simply facing the SQL standard behavior of the | operator when it compares something to a NULL value, the whole result will be NULL. </div><div>In SQL, you can avoid that by wrapping each value in a "coalesce(myvalue, '')" that will replace NULL by an empty string. </div><div><br></div><div>In QGIS, you can also use the "+" operator, and this one does not sends a NULL like the pipe operator. Far more simple indeed, but less portable to pure SQL . </div><div>Cheers</div><div>Régis</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-12-21 3:33 GMT+01:00 damos <span dir="ltr"><<a href="http:///user/SendEmail.jtp?type=node&node=5300800&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>></span>:<br><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' style="border-left:2px solid #cccccc;padding:0 1em" class="gmail_quote">HI I am trying to do a nested case statement for a labelling task.<br>
I have a list of mines of varying sizes with different commodities and would<br>
like to label with the name of the mine and the amount of each commodity at<br>
the mine in a new line below the name. I only want to label the mines that I<br>
have decided are signifcant and for this I have made a new column in my<br>
table called significant.<br>
My difficulty is that not all mines have the same commodities, for example<br>
one mine has copper (Cu) and no lead(Pb), while another has both. yet<br>
another will only have Pb.<br>
i can easily label all of the sigificant mines and their copper amoutns with<br>
a suffix of kt Cu using this code:<br>
<br>
case when "signifcant" = 'yes' then title( "Name" ) || '\n' || case<br>
when "Cu_e_t" <1 then '' else round("Cu_e_t"/1000,0) || 'Kt Cu' end else<br>
null end<br>
<br>
however if I then try to add in the Pb amounts like this;<br>
case when "signifcant" = 'yes' then title( "Name" ) || '\n' || case<br>
when "Cu_e_t" <1 then '' else round("Cu_e_t"/1000,0) || 'Kt Cu' end ||<br>
case when "Pb_e_t" <1 then '' else round("Pb_e_t"/1000,0) || 'Kt Pb' end<br>
else null end<br>
<br>
I lose all of the Cu only mines and only get labels for those with Cu and Pb<br>
or just Pb.<br>
I understand that I am doing something wrong with the nested case<br>
statements, but cant figure out what.<br>
<br>
any help would be much appreciated.<br>
int the mean time I am going back to do the formula in excel where I am<br>
capable.<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/using-nested-case-statements-in-labelling-tp5300779.html" rel="nofollow" link="external" target="_blank">http://osgeo-org.1560.x6.nabbl<wbr>e.com/using-nested-case-statem<wbr>ents-in-labelling-tp5300779.ht<wbr>ml</a><br>
Sent from the Quantum GIS - User mailing list archive at Nabble.com.<br>
______________________________<wbr>_________________<br>
Qgis-user mailing list<br>
<a href="http:///user/SendEmail.jtp?type=node&node=5300800&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/qgis-user</a></blockquote></div><br></div>
<br>______________________________<wbr>_________________
<br>Qgis-user mailing list
<br><a href="http:///user/SendEmail.jtp?type=node&node=5300800&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/qgis-user</a><br>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/qgis-user</a>
<div class="m_7117417421327630531m_-8842594732393931888signature" style="margin-top:1em;color:#666666;font-size:11px">
------------------------------<wbr>----
<br>Régis Haubourg
<br>GIS administrator and project manager
<br>Administrateur de données géographiques et chef de projet SIG
<br>Agence de l'eau Adour-Garonne
<br>
</div>
<br>
<br>
<hr noshade size="1" color="#cccccc">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/using-nested-case-statements-in-labelling-tp5300779p5300800.html" target="_blank" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabbl<wbr>e.com/using-nested-case-statem<wbr>ents-in-labelling-tp5300779p53<wbr>00800.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from using nested case statements in labelling, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></blockquote></div></div>
</blockquote></div></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/using-nested-case-statements-in-labelling-tp5300779p5301028.html">Re: using nested case statements in labelling</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>