topic Re: Colors on Charts in QlikView

Colors on Charts

Thu, 13 Mar 2014 11:12:09 GMT

I have a bar chart with data for different months. Previously the months were different colors on the bar chart (January was blue, February was red, etc). I added a line to my chart to show some different data and now all the months are blue. Is there a way to have the bars be multi-colored while still having the line?

Re: Colors on Charts

MK_QSL — Thu, 13 Mar 2014 11:21:22 GMT

Can you share your sample FILE or sample Data?

UPDATE : I think you are talking about COMBO Chart...

Multicolored in Combo chart

Re: Colors on Charts

jsingh71 — Thu, 13 Mar 2014 11:28:12 GMT

Hi Manish,

May be he is looking for multi-colour option in Combo Chart. If we add only one expression( presentation Bar) then it was shows different colour in each bar but once we add one more expression (Presenation Line) then all the Bar now showing to similar color only.

May be multi-color for bar is not possible in combo chart when we add more then one expression.

Please suggest.

Re: Colors on Charts

jsingh71 — Thu, 13 Mar 2014 11:45:49 GMT

Hi Manish,

I follow your link and got the result. Thank you for sharing.

Michael

You need to put expression in Background Colour. Replace 'City' with your Dimention name.

Re: Colors on Charts

Thu, 13 Mar 2014 12:01:36 GMT

Hi ,

If you are using one dimension then check on Multicolored other wise check Persistent colors as shown in the image

Regards

Kumar

Re: Colors on Charts

Thu, 13 Mar 2014 12:06:38 GMT

This has changed it so that there are colors but still not quite what I want. With this code each city is a different color. What I need is for each month to be a different color. January will be blue for every city, February will be red for each city, etc.

Also I have two dimensions, the second on is a drill down.

Thanks

Re: Colors on Charts

jsingh71 — Fri, 14 Mar 2014 06:35:11 GMT

Hi Michael,

If you want specific color for each field then use below expression:

if(FieldIndex('Month',Month)=3,Green(),
if(FieldIndex('Month',Month)=1,Blue(),
if(FieldIndex('Month',Month)=2,Red(),)))

in the same under background color. Replace month with your dimension name.