0 Replies Latest reply: Apr 3, 2017 5:06 AM by Joost Potting RSS

    Colormix, only 1 selected value

    Joost Potting

      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