Adding multiple colors to 1 line in a bar chart based on value

[Anonymous]

Hello guys

I am using Qlikview for a couple of days now and altough I understand most basic things, when it comes to formatting, it get's really hard.

So what I want to do: I have a bar chart with multiple bars representing a percentage between 0 and 100%. At this moment, Qlikview just gives me the standard colors, for my case, 2016 is Blue and 2017 is Red for each country. But what I want to do is: the first 90% of every bar, should be red. If a bar has more than 90%, then the 90%-95% Should be yellow. Lastly, if there are bars more than 95%, the 95%-100% should be green. I have absolutly no idea how to get this done.

Thanks in advance!!

[kamal_sanguri · Accepted solution]

Please find this document, where I have formatted bars in a way that any value greater than 90% would be shown as Green bar and less than that would be red.

[Sergey_Shuklin]

Hello, Brent!

You can also find something usefull here:

Visual tricks with Charts‌

[kamal_sanguri]

Also, rather than using color function like Red(), Green() etc. you can also use RGB function to set color of your preference.

[Anonymous]

Though very helpful (you got my helpful mark ), it does not do what I wanted exactly. But since this is even better, I will just flag this as solved.

Thanks!

[kamal_sanguri]

lol.. glad you liked that.

[Anonymous]

Yes, thank you a lot. I used this already and it worked perfectly (well almost but that's prob just my bad).