I am trying to categorise my site points by species group with rule based symbology;
e.g. bat uses the formula
"Group"='Bat'
But I would also like to have a different symbol for where there are no bats recorded at that site (i.e. based on the abundance in a separate column which is taken from a join with another table). I have tried this below but it hasn't worked, does anyone know how to fix this?
"Group"='Bat' AND "records_Abundance" = '<= 0' (for sites where species not present)
"Group"='Bat' AND "records_Abundance" = '>= 1' (for sites where species are present)
It seems to only read the abundance part and either turns all my points for all species to the symbol or none at all?
if(records_Abundance LIKE '<=0',0,2)
as condition for the size of the point-symbol - it gives no symbol, when the amount of bats is 0, else it gives a symbol 2 units wide. Also, for meCASE WHEN group='Bat' AND records='<= 0' THEN TRUE END
does work - as well as any variations with spaces and/or quotation marks. – Erik Nov 12 at 12:26"records_Abundance"
). – Joseph Nov 13 at 10:24