topic Total Column color in Bar Chart in QlikView

Total Column color in Bar Chart

Mon, 25 Mar 2013 10:17:21 GMT

Hi,

I have a Bar Chart with "Show Total" checkbox selected for my dimension.

Total info is correctly displayed but bar color is the same of the rest of columns .. How can I set a specific color for this Total column?

"Total color" from Colors Tab is not being used ..

Thanks,

Mon, 25 Mar 2013 10:34:49 GMT

I've found this way to do it

if(Dimensionality()=0,color(2)) in Background color Expression column

Although this does not clarify me why "Total Color" from Colors tab is not being automatically applied ..

Gabriel — Mon, 25 Mar 2013 11:55:02 GMT

Hi,

Have you tried Multi Color from Colors tab in chart properties?

If not give it a go and let us know if this work.

Regards,

Gabriel.

tduarte — Fri, 13 Sep 2013 09:40:01 GMT

Hi, also trying to set a fixed color for the Total bar in QV10..

Already tried if(Dimensionality()=0, LightRed()) on the Expression -> Background Color but it doesn't work.

Really simple on a table but not working on the chart.

Any ideas?

Gysbert_Wassenaar — Fri, 13 Sep 2013 09:59:03 GMT

Try something like:

if(match(MyDim, concat(distinct MyDim ,',')),color(1), color(2))

Replace MyDim with the name of the dimension you use in your bar chart

tduarte — Fri, 13 Sep 2013 11:38:12 GMT

Nice one, it works!

Thanks.