Colouring based on Dimension in QlikMaps for Qlik Sense

[Anonymous]

Hello,

I am currently working on creating a colouring scheme for a qlik map drawing that checks if a field (called SID) is null for each polygon in a map and colours it red if Null and green otherwise.

Currently I have a sample grouping that is shown in the attached photo. 2 of these space should be red while the rest should show as green.

The expressions I have tried in an attempt to achieve this are:

=if(SID='','red()','green()')               This results in all the polygons being green.

=if(isNull(SID)=0,'green()','red()')   This results in all polygons being red.

=if(count(SID)=1,'green()','red()')   This results in all polygons being red.

I am wondering if this syntax takes the aggregation of all rows instead of on a 1-by-1 basis which would result in all of the spaces being colored the same. And, if so is there a syntax that would result in each polygon being evaluated individually?

[Anonymous]

Note that upon looking at Qlik Sense documentation I see that these operators I am trying to use only apply to numeric values and cannot be used for strings.