Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Differential colour for different valued bars in bar chart

Hi,

Hope the attached file helps you.

Regards,

Jagan.

9 Replies
MVP
MVP

Re: Differential colour for different valued bars in bar chart

Hi,

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

Hope the attached screenshot will helps you.

Regards,

Jagan.

MVP
MVP

Re: Differential colour for different valued bars in bar chart

Hi,

Hope the attached file helps you.

Regards,

Jagan.

chandashok
Contributor III

Re: Differential colour for different valued bars in bar chart

Hi

     Hope this attached file will be helpful for your requirement.

Regards

Ashok

Not applicable

Differential colour for different valued bars in bar chart

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?

chandashok
Contributor III

Differential colour for different valued bars in bar chart

Hi

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

     Its have the solution for your question.

Regards

Ashok

MVP
MVP

Differential colour for different valued bars in bar chart

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

Re: Differential colour for different valued bars in bar chart

Hi Jagan,

This is not giving any results ☹

MVP
MVP

Differential colour for different valued bars in bar chart

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

Differential colour for different valued bars in bar chart

Hey Jagan,

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

Community Browser