Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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