topic Re: Bar Chart color issue............. in QlikView

Bar Chart color issue.............

Nagaraju_KCS — Wed, 26 Feb 2014 14:12:20 GMT

Hi Experts,

How to give different color in BAR chart Dimension.........

PFA,.....

Thanks in Advance..............

Re: Bar Chart color issue.............

Clever_Anjos — Wed, 26 Feb 2014 14:14:31 GMT

Sorry, it´s not possible.

The label colors for dimensions are set by graph, not by row/column

Re: Bar Chart color issue.............

Nagaraju_KCS — Wed, 26 Feb 2014 14:19:45 GMT

Hi Clever,

It's possible but only one color......

Properties -----> Axis Tab----> Dimensions Axis ----> Font ---->Color

But i don't know is it possible or not multiple color's..............

Re: Bar Chart color issue.............

Clever_Anjos — Wed, 26 Feb 2014 14:25:58 GMT

That´s what I was saying you can set it by graph, choosing one color

Re: Bar Chart color issue.............

DavidFoster1 — Wed, 26 Feb 2014 14:28:18 GMT

If you want a different colour from each bar then you can choose Multicoloured on the colour properties tab. If you want to control the colour of a specific bar then you use the background colour property on the bar expression.

Re: Bar Chart color issue.............

Nagaraju_KCS — Wed, 26 Feb 2014 14:43:32 GMT

But we have Calculated expression.. i.e also not working..

Re: Bar Chart color issue.............

DavidFoster1 — Wed, 26 Feb 2014 14:49:21 GMT

You can only set the font colour for

dimension axis
measure axis
data labels

You might be able to change the colour of the data labels dynamically using the expression properties.

Re: Bar Chart color issue.............

stevedark — Wed, 26 Feb 2014 14:49:34 GMT

That will do the bars, but not the labels. If the bar colour expression is not working please post it here as text and we can debug.

The only way you will get coloured labels is by having each as text in chart. You would have to ensure that there was never any chance of new plants appearing or any being excluded by selections.

Just another observation, you should probably set the line on the chart to be symbols (eg. circles) instead of a line - as there is no linear relationship between plants.

Hope that helps,

Steve

Re: Bar Chart color issue.............

Nagaraju_KCS — Wed, 26 Feb 2014 14:52:30 GMT

Hi All,

Thanks for Explanation...............

Re: Bar Chart color issue.............

antoniotiman — Wed, 26 Feb 2014 14:53:32 GMT

Re: Bar Chart color issue.............

Clever_Anjos — Wed, 26 Feb 2014 15:52:23 GMT

you right about having that calculated field.

But its calculated only once to whole graph