Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

MayilVahanan

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?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Mayil,

Thanks for your reply. Its working now.

Regards

Siva Rama