topic Re: How to fix Colors in a Combo Chart in QlikView

How to fix Colors in a Combo Chart

danialier — Tue, 21 Jan 2014 16:43:44 GMT

Hello,

Do you know how I can fix the colors in a Combo Chart where I have multiple lines and bars ? What happens is that when I select a country or another one in a List Box, the colors of all lines and bars from the Combo Chart get changed...

Thanks,

dani

Re: How to fix Colors in a Combo Chart

Nicole-Smith — Tue, 21 Jan 2014 16:45:42 GMT

On the colors tab, check the box for "Persistent Colors".

Re: How to fix Colors in a Combo Chart

danialier — Tue, 21 Jan 2014 16:53:44 GMT

Hi Nicole,

Thanks. And how I can assign an specific color to any specific country. I mean I want each country to be colored in an specific color (i.e. Germany in blue, China in red, US in green,...)

Re: How to fix Colors in a Combo Chart

danialier — Tue, 21 Jan 2014 16:55:55 GMT

· Hi Nicole,

Thanks. And how I can assign an specific color to any specific country. I mean I want each country to be colored in an specific color (i.e. Germany in blue, China in red, US in green,...)

Thanks,

dani

Re: How to fix Colors in a Combo Chart

Nicole-Smith — Tue, 21 Jan 2014 16:57:08 GMT

On your expression, click the + sign next to it, then for Background Color, you can put an expression like:

pick(match(YourCountryField, 'Germany', 'China', 'US'), rgb(0,0,255), rgb(255,0,0), rgb(0,255,0))

Re: How to fix Colors in a Combo Chart

Clever_Anjos — Tue, 21 Jan 2014 17:04:38 GMT

I sugest you having an inline table to configure each color to each country and then using your "Color" field as a background color expression

LOAD F1 as Country,

RGB(subfield(F2,',',1),subfield(F2,',',2),subfield(F2,',',3)) as Color

INLINE [

F1, F2

China, "255,0,0"

Brazil, "0,255,255"

];

Re: How to fix Colors in a Combo Chart

danialier — Tue, 21 Jan 2014 17:08:31 GMT

Thanks Nicole !

I tried on that what when applying the updates my Combo Chart is showing as message as follows: “Allocated memory exceeded” and chart disappears automatically…. What does it mean ???

Thanks !

dani

Re: How to fix Colors in a Combo Chart

Nicole-Smith — Tue, 21 Jan 2014 17:09:30 GMT

It most likely means there is something wrong with your expression. Can you please copy what you have onto here so I can see it? Or even better yet, post a .qvw file.

Re: Re: How to fix Colors in a Combo Chart

Nicole-Smith — Tue, 21 Jan 2014 17:11:14 GMT

Also, here is a working example (attached).

Re: How to fix Colors in a Combo Chart

danialier — Tue, 21 Jan 2014 17:20:22 GMT

Excellent Nicole !!! it works now. many thanks for your support.

Best regards,

dani