Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

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
Highlighted
MVP
MVP

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

In this case you have to use 3 expressions.

Highlighted
Creator III
Creator III

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

HI,

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

Thank,

Sandip

Highlighted
Creator III
Creator III

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

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

Highlighted
Creator III
Creator III

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

Dear Sandip,

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

Best Regards

Highlighted

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

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

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)
Highlighted

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

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

Highlighted
Creator III
Creator III

Re: Multiple Colors In 1 Single Bar Of A Bar Chart

Dear Marco,

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

Best Regards

QianNing