topic Multiple colour in bar chart for same expression in QlikView

Multiple colour in bar chart for same expression

raghavsurya — Tue, 13 Jul 2010 12:27:08 GMT

Hi All,

I need to get different colour for a Bar when the value is in negative.

For example : I have a bar chart where dimension is Cost centre with values A,B,C,D,E and profit is the expression where it shows five Bars for each cost centre. suppose if Cost centre D is have loss....the bar depicting net loss for cost centre should show in red colour wherein other bars should show in Green.

Is there a way to do it.

Thanks and Regards,

Raghav

Multiple colour in bar chart for same expression

sparur — Tue, 13 Jul 2010 12:51:55 GMT

you should use background color expression. See in Expression tab on your expression and use like this:

if(sum(Amount )<0, red(), green())

Multiple colour in bar chart for same expression

kji — Tue, 13 Jul 2010 12:52:13 GMT

Add a Background color subexpression to your expression in which you put if(profit>0, Green(), Red()).

Multiple colour in bar chart for same expression

Tue, 13 Jul 2010 13:10:39 GMT

Hi Raghav,

Apart from color change, it is also possible to avoid shift in zero base of chart.

i.e. even negative value bar will go up (like positive values) but color will be changed.

Just look at the attachment.

Sincere Regards,

RBA

Multiple colour in bar chart for same expression

raghavsurya — Tue, 13 Jul 2010 13:59:35 GMT

Hi All,

Thanks a lot.... its working for me.

Regards,

Raghav