Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

color coding for each bar in the bar chart

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

3 Replies
Not applicable

Re: color coding for each bar in the bar chart

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

Re: color coding for each bar in the bar chart

HI

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?

Not applicable

Re: color coding for each bar in the bar chart

Mayil,

Thanks for your reply. Its working now.

Regards

Siva Rama

Community Browser