<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Just press on the "E" Expression button and concatenate the two
    columns:<br>
    <br>
    Z1 || ' ' || Z6<br>
    <br>
    Press Categorize and delete all the combinations you don't need.<br>
    <br>
    Andreas<br>
    <br>
    <div class="moz-cite-prefix">On 26.06.2015 14:38, Lester Anderson
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAE3taFAaQnDwsc1qjR3RTjSDDe4yRqWTMoT2pLb0OSicJRcTVQ@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
          <div>
            <div>It is the categorised / graduated render I was looking
              at. I could not figure out the correct SQL expression for
              the column section; how would this expression be written
              here?<br>
              <br>
            </div>
            eg Find all values where Z6=0 and render Z1 for the
            symbology associated with that particular Z6 value<br>
            <br>
          </div>
          Cheers<br>
        </div>
        Lester<br>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On 26 June 2015 at 13:22, Andreas
          Neumann <span dir="ltr"><<a moz-do-not-send="true"
              href="mailto:a.neumann@carto.net" target="_blank">a.neumann@carto.net</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div text="#000000" bgcolor="#FFFFFF"> Hi Lester,<br>
              <br>
              You can either use an expression which uses more than one
              column (for graduated or categorized renderer) or the rule
              based renderer mentioned by Carlos, which is more
              powerful.<span class="HOEnZb"><font color="#888888"><br>
                  <br>
                  Andreas</font></span>
              <div>
                <div class="h5"><br>
                  <br>
                  <div>On 26.06.2015 12:57, Lester Anderson wrote:<br>
                  </div>
                </div>
              </div>
              <blockquote type="cite">
                <div>
                  <div class="h5">
                    <div dir="ltr">
                      <div>
                        <div>
                          <div>
                            <div>
                              <div>
                                <div>
                                  <div>Hi,<br>
                                    <br>
                                  </div>
                                  I have a point database loaded with
                                  columns Z1 to Z6, where Z6 has values
                                  0,0.5 and 1. What I am trying to do
                                  with the symbology is just to get it
                                  to plot and colour the depths (Z1)
                                  only where Z6=0<br>
                                  <br>
                                </div>
                                Can this be done from the style option
                                for the layer?<br>
                                <br>
                              </div>
                              So what I want to do is:<br>
                              <br>
                            </div>
                            IF Z6=0 PLOT Z1<br>
                            <br>
                          </div>
                          Sure this is very simple but can't see it :)<br>
                          <br>
                        </div>
                        Cheers<br>
                        <br>
                      </div>
                      Lester<br>
                    </div>
                    <br>
                    <fieldset></fieldset>
                    <br>
                  </div>
                </div>
                <span class="">
                  <pre>_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
<a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
                </span></blockquote>
              <br>
            </div>
            <br>
            _______________________________________________<br>
            Qgis-user mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
            <a moz-do-not-send="true"
              href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
              rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
  </body>
</html>