topic Color code a stacked bar chart based on value in QlikView

Color code a stacked bar chart based on value

Krish — Wed, 22 Dec 2021 12:16:44 GMT

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.

Re: Color code a stacked bar chart based on value

Or — Wed, 22 Dec 2021 13:23:30 GMT

Re: Color code a stacked bar chart based on value

Krish — Wed, 22 Dec 2021 16:42:30 GMT

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

Re: Color code a stacked bar chart based on value

Or — Thu, 23 Dec 2021 11:18:53 GMT

Re: Color code a stacked bar chart based on value

Krish — Thu, 23 Dec 2021 12:38:43 GMT

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

Re: Color code a stacked bar chart based on value

Or — Thu, 23 Dec 2021 12:53:24 GMT

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

Re: Color code a stacked bar chart based on value

markwood — Mon, 27 Dec 2021 12:09:24 GMT

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