Color code a stacked bar chart based on value

[Krish]

Hi,

      I am trying to create a Stacked bar chart and color code the values based on below criteria.
  When the measure value is 100.0 then green, if it between 90 and 99.9 then blue and red when the value is less than 90. How can this be achieved in stacked bar chart.

[Or]

[Krish]

I am sorry. Forgot to mention. This is on QlikView.

[Or]

[Krish]

Thanks for the response. How to write the condition when the value is between 90 and 99?

[Or · Accepted solution]

Nest two If() statements, same as you would with any other condition in Qlik, e.g.
If(Something,Red(),If(SomethingElse,Blue(),Green()))

[markwood]

I'm trying to implement on my website : https://modhappy.com/