
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
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----)
