Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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!!

1 Solution

Accepted Solutions
kamal_sanguri
Specialist
Specialist

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.

Capture.PNG

View solution in original post

6 Replies
kamal_sanguri
Specialist
Specialist

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.

Capture.PNG

Sergey_Shuklin
Specialist
Specialist

Hello, Brent!

You can also find something usefull here:

Visual tricks with Charts

kamal_sanguri
Specialist
Specialist

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

Anonymous
Not applicable
Author

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
Specialist
Specialist

lol.. glad you liked that.

Anonymous
Not applicable
Author

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