# 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
Did you mean:
Highlighted
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!

1 Solution

Accepted Solutions
Highlighted
MVP

## 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:

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

hope this helps

regards

Marco

7 Replies
Highlighted
MVP

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

In this case you have to use 3 expressions.

Highlighted
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

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

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

## 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:

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

hope this helps

regards

Marco

Highlighted
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