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

Differential colour for different valued bars in bar chart

Hey,

I have a bar chart which features market-share value of different products. Can i set an expression so that i get all the bars for the products having market share value more than a particular value say 15,000 in one colour and the others in other?

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Hope the attached file helps you.

Regards,

Jagan.

View solution in original post

9 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

You can use the Background Color expression to change the color.

Hope the attached screenshot will helps you.

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Hope the attached file helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author

Hi

     Hope this attached file will be helpful for your requirement.

Regards

Ashok

Not applicable
Author

Hey Jagan,

Thanks for replying, but could you please tell me how did you get that option of changing background colour in expressions for sales?

Anonymous
Not applicable
Author

Hi

     You just check the image file which jagan attached in this thread.

     Its have the solution for your question.

Regards

Ashok

jagan
Luminary Alumni
Luminary Alumni

Hi,

Just expand(Click) the + symbol before the expression, you will find "BackgroundColor" below, click this and give the expression

=If(Sum(Sales) > 1000, RGB(0,0,255), RGB(0,255,0))

in Definition(Expression) textbox.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Hi Jagan,

This is not giving any results ☹

jagan
Luminary Alumni
Luminary Alumni

Hi,

Did you replaced this expression "Sum(Sales)" with your expression?

If possible attach the sample file.  you can check the same in attached files by me and Ashok.

Regards,

Jagan.

Not applicable
Author

Hey Jagan,

Thanks a lot for the help..it really worked!!