Colormix, only 1 selected value

joost_potting — Mon, 03 Apr 2017 09:06:41 GMT

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?

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----)

topic Colormix, only 1 selected value in App Development

Colormix, only 1 selected value