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

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

Anonymous — Thu, 01 Jun 2017 09:47:52 GMT

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

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

kamal_sanguri — Fri, 02 Jun 2017 06:21:07 GMT

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.

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

Sergey_Shuklin — Fri, 02 Jun 2017 06:26:22 GMT

Hello, Brent!

You can also find something usefull here:

Visual tricks with Charts‌

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

kamal_sanguri — Fri, 02 Jun 2017 06:34:12 GMT

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

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

Anonymous — Thu, 15 Jun 2017 07:52:18 GMT

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!

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

kamal_sanguri — Thu, 15 Jun 2017 08:01:41 GMT

lol.. glad you liked that.

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

Anonymous — Thu, 15 Jun 2017 08:16:11 GMT

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