topic Re: color coding for each bar in the bar chart in QlikView

color coding for each bar in the bar chart

Wed, 28 Nov 2012 17:36:10 GMT

Hello friends,

i have to display the trend chart(bar chart for 12 months data) in 3 different colors (red, green, amber) depends on the threshold value(RAG values).

Dimension : Month

Expression:

=Sum ([Abs (FTE)])/Sum ([Avail (FTE)])

and the value of backgroud Color property of this expression is

=if( Sum ([Abs (FTE)])/Sum ([Avail (FTE)]) <3.79 ,RGB(69,234,21), if (Sum ([Abs (FTE)])/Sum ([Avail (FTE)])<4, rgb(255,128,0), RGB(255,0,0)))

But iam getting one color for the all the months, Please check the attachment for the reference.

Please help me.

Regards

Siva

Wed, 28 Nov 2012 17:46:35 GMT

in the properties, color tab, mark the multicolor box.

MayilVahanan — Wed, 28 Nov 2012 17:47:49 GMT

Its showing in precentage value.. so related to that value, given in background color.

Check the 3.79 values , its either the percentage value or actual value..

May be its helps..Can you post a sample file?

Thu, 29 Nov 2012 09:30:10 GMT

Mayil,

Thanks for your reply. Its working now.

Regards

Siva Rama