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

Graph Colors Change with Data (based on expression)

I'm trying to get graph to display Bar colors based on data Values.  So far it only takes value of first data set .  For example if Group(X Axes)  is below 50 then all bars turn same color as the first bar (Red).  How can I get Bars to change to color according to Data based on Group(X Axes).

Example:  Group1 >50 Then Green , Group2 < 50 Then Red,  etc...

 

This is the formula I'm trying

 

= if(avg([ Group %Tile]) >= 50 ,RGB(0,145,72), RGB(237,28,46))

RGB are custom colors for report

1 Solution

Accepted Solutions
Not applicable
Author

Hi!

Try putting the formula in place as shown below:

Exemplo.jpg

Att.

Rebeca

View solution in original post

5 Replies
Not applicable
Author

Hi!

Try putting the formula in place as shown below:

Exemplo.jpg

Att.

Rebeca

Not applicable
Author

Rebecca,

Thank you . It works adding it to the Background Color .

Thank you....

ZD

Not applicable
Author

Rebecca,

Thank you . It works adding it to the Background Color .

Thank you....

ZD

Not applicable
Author

This was the answer. Thank you.....

ZD

Not applicable
Author

Thank you so much!