topic Re: Multiple Colored Bars in Dual Axis Chart in QlikView

Multiple Colored Bars in Dual Axis Chart

jmonroe918 — Wed, 16 Sep 2015 22:16:02 GMT

I have created a Chart that uses both Y-axes. Left axis is Complaints (bar chart) and Right axis is Defect Rate % (Diamonds). By using this feature I no longer have the ability to select "Mulitcolored" for the bars (they are all blue). I would like them to be multicolored.

I have created conditions in the past based on > or < certain % would be represented by a certain color, but the bar charts are based on numbers and I don't want them colored based on their number. Just random.

Does anyone know of an expression that will give each bar its own color?

Thanks.

Jeff

Re: Multiple Colored Bars in Dual Axis Chart

MarcoWedel — Wed, 16 Sep 2015 23:25:34 GMT

Hi,

the reason for the "Multicolored" being greyed out is your two expressions rather than the separate axes.

To multicolor the bars you could use a background color expression like:

hope this helps

regards

Marco

Re: Multiple Colored Bars in Dual Axis Chart

jmonroe918 — Thu, 17 Sep 2015 14:53:47 GMT

Marco:

Worked like a charm!

Thanks so much.

Jeff