[Qgis-user] SQL query for style

[Andreas Neumann]

Just press on the "E" Expression button and concatenate the two columns:

Z1 || ' ' || Z6

Press Categorize and delete all the combinations you don't need.

Andreas

On 26.06.2015 14:38, Lester Anderson wrote:
> 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?
>
> eg Find all values where Z6=0 and render Z1 for the symbology 
> associated with that particular Z6 value
>
> Cheers
> Lester
>
> On 26 June 2015 at 13:22, Andreas Neumann <a.neumann at carto.net 
> <mailto:a.neumann at carto.net>> wrote:
>
>     Hi Lester,
>
>     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.
>
>     Andreas
>
>
>     On 26.06.2015 12:57, Lester Anderson wrote:
>>     Hi,
>>
>>     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
>>
>>     Can this be done from the style option for the layer?
>>
>>     So what I want to do is:
>>
>>     IF Z6=0 PLOT Z1
>>
>>     Sure this is very simple but can't see it :)
>>
>>     Cheers
>>
>>     Lester
>>
>>
>>     _______________________________________________
>>     Qgis-user mailing list
>>     Qgis-user at lists.osgeo.org  <mailto:Qgis-user at lists.osgeo.org>
>>     http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150626/79d7eb88/attachment.html>