Geo Maps Color by expression is not working

PamelaAlcantara — Wed, 10 Jun 2020 18:10:22 GMT

Hi all,

I am having a issue while trying to establish a color by expression on a chart layer. Every time the number of items is bigger than 1, the color is gray.

Dimension = Country

Slice = Rank

Measure: # Items

If I use the color by dimension (Slice) I get the correct visualization with the Qlik Sense default colors. When I try to use the color by expression:

=if( Rank<=20, 'green', if (Rank>20 and Rank<=40, 'yellow', if (Rank>40, 'red')))

The expression work but only when the #Items = 1, as soon as I get more than one, the color goes to gray.

Does anyone know how to solve this issue?

Thank you,

Pamela

Re: Geo Maps Color by expression is not working

fosuzuki — Wed, 10 Jun 2020 19:36:17 GMT

Try this:

=if( Only(Rank)<=20, 'green', if (Only(Rank)>20 and Only(Rank)<=40, 'yellow', if (Only(Rank)>40, 'red')))

topic Geo Maps Color by expression is not working in App Development

Geo Maps Color by expression is not working

Re: Geo Maps Color by expression is not working