Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
brentviata
Contributor III
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
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

View solution in original post

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.

brentviata
Contributor III
Contributor III
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.

brentviata
Contributor III
Contributor III
Author

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