topic Re: colour 3 bars in a chart the same colour in QlikView

colour 3 bars in a chart the same colour

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to color 3 bars in a Bar Chart red but a fourth one blue.

=If([BulbGroup]= '[daffodil]',RGB(255,0,0),

If([BulbGroup]= 'hyacinth', RGB(255,0,0),

if([BulbGroup]= 'Freesia',RGB(255,0,0), RGB(0,0,255))))

I have tried different versions of this code but none have worked.

Any ideas what I can do instead?

Re: colour 3 bars in a chart the same colour

sunny_talwar — Wed, 14 Sep 2016 18:58:34 GMT

May be like this:

=If(Match([BulbGroup], 'daffodil', 'hyacinth', 'Freesia'), RGB(255,0,0), RGB(0,0,255)

Re: colour 3 bars in a chart the same colour

MK9885 — Wed, 14 Sep 2016 19:14:58 GMT

Can you upload a sample qvw?

Re: colour 3 bars in a chart the same colour

Anonymous — Wed, 14 Sep 2016 21:13:56 GMT

I have tried this & it does not work; I can't upload the qvw

Re: colour 3 bars in a chart the same colour

Anonymous — Thu, 15 Sep 2016 08:53:39 GMT

It does not work, sorry!

Re: colour 3 bars in a chart the same colour

MK9885 — Thu, 15 Sep 2016 16:03:34 GMT

We can achieve it another way.

Can you at least share screenshot of that bar chart?

How many bars are there and what color you need?

Re: colour 3 bars in a chart the same colour

MK9885 — Thu, 15 Sep 2016 16:12:56 GMT

What you can do here is

Check the colors of your bar, in your case

3 bars

1. Daffodil

2. Hyacinth

3. Freesia

So for Freesia if the color is Off Green (example) so click on 3rd color and give an color expression as if([BulbGroup]= 'Freesia',RGB(255,0,0), RGB(0,0,255))

And you can keep Daffodil and Hyacinth as Red by selecting the color number

Note: After you make these changes do not forget to check the 'Persistent Color' box on the right side.

If you using only single dimension then first check the 'Multicolored box' and hit apply. After then you'll see bar colors here and you can change it with regards to what number your bar is placed.