Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
joost_potting
Partner - Contributor
Partner - 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

0 Replies