Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s10157754
Creator III
Creator III

Multiple Colors In 1 Single Bar Of A Bar Chart

Dear Qlikview Experts,

I was thinking is it possible for Qlikview to achieve multiples colors in 1 single bar within a bar chart diagram? There is only 1 dimension and 1 expression. For example, sum(A) / sum(B).

If the bar is 90%, then 0%-30% should be green, 31%-60% should be yellow and 61%-90% should be red. So is it possible for it to have different color representation for individual range of %?

Something like the picture shown below? Thanks for your help in advance!

Capture.PNG

1 Solution

Accepted Solutions
MarcoWedel

Hi,

solutions might be either


  • a bar chart with additional synthetic dimension like this:

QlikCommunity_Thread_297326_Pic3.JPG

QlikCommunity_Thread_297326_Pic4.JPG

QlikCommunity_Thread_297326_Pic5.JPG

  • or a straight table with linear gauge representation of your expression:

QlikCommunity_Thread_297326_Pic1.JPG

QlikCommunity_Thread_297326_Pic2.JPG

hope this helps

regards

Marco

View solution in original post

7 Replies
MK_QSL
MVP
MVP

In this case you have to use 3 expressions.

ananyaghosh
Creator III
Creator III

HI,

Are you want to show the single bars with 3 different colors? or at different bars with different colors?

Thank,

Sandip

s10157754
Creator III
Creator III
Author

Dear Kachhia,

Sorry for the late reply. I only have 1 expression, so I was looking for some functions there are able to display different colors for individual range of %.

Best Regards

s10157754
Creator III
Creator III
Author

Dear Sandip,

Sorry for the late reply, I was looking for a way to show the single bar with 3 different colors.

Best Regards

Anil_Babu_Samineni

Yes, For single expression copy three times to get 3 different colors in single Graph

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MarcoWedel

Hi,

solutions might be either


  • a bar chart with additional synthetic dimension like this:

QlikCommunity_Thread_297326_Pic3.JPG

QlikCommunity_Thread_297326_Pic4.JPG

QlikCommunity_Thread_297326_Pic5.JPG

  • or a straight table with linear gauge representation of your expression:

QlikCommunity_Thread_297326_Pic1.JPG

QlikCommunity_Thread_297326_Pic2.JPG

hope this helps

regards

Marco

s10157754
Creator III
Creator III
Author

Dear Marco,

Thank you so much for the solution and it works perfectly for me!

Best Regards

QianNing