Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joost_potting
New Contributor

Colormix, only 1 selected value

Hi all,

I am currently experimenting with coloring a map using colormix. Via the ColorStyler extension (Qlik Branch) I have created the needed colors for a high and a low value. However, if I select one country the country is colored grey (as expected).

I tried to give this country a color, but failed. Do you know how I would achieve this?

Country Colors.png

Color code:

ColorMix1((1+Sign(2*(Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100)-RangeMin (top(total Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100),1,NoOfRows(total))))/(RangeMax (top(total Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100),1,NoOfRows(total)))-RangeMin (top(total Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100)-RangeMin (top(total Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100),1,NoOfRows(total))))/(RangeMax (top(total Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100),1,NoOfRows(total)))-RangeMin (top(total Round((sum(If([StatusValue]>1,1,0))

/

Count(AttributeID))

*100),1,NoOfRows(total))))-1))))/2,argb(255,0,148,130),argb(255,157,22,46))

Using an If statement with the following does not work

IF(Count(GetFieldSelections(CountryLabel))=1 , Green(),

     Colormix Code----)

Country Colors 1 country.png