Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

brentviata
New Contributor III

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
Valued Contributor

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

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

6 Replies
kamal_sanguri
Valued Contributor

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

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

serj_shu
Valued Contributor

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

Hello, Brent!

You can also find something usefull here:

Visual tricks with Charts

kamal_sanguri
Valued Contributor

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

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

brentviata
New Contributor III

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

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
Valued Contributor

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

lol.. glad you liked that.

brentviata
New Contributor III

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

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

Community Browser