Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

Bar chart colors need change based on measure value

I have bar chart with 3 measures. I have write the condition for bars based on it's measured value. 

Ex: Total Sales and Total Profit bar is there. I have to arrange the bar color , if Sales>75 GREEN() otherwise RED(), If Profit > 75 Blue() otherwise RED()

2 Replies
Channa
Specialist III
Specialist III

create master measure ITEMS and use 

 

hear you have default % chage to flexible

Channa
R_Kaymakchiev
Luminary Alumni
Luminary Alumni

You can create two master items and have a color expression for each of them.

example:    If( [Profit ] >100, rgb(91,160,228), rgb(202, 102, 117) )

download.jpg

As far as I know, currently there is no way to specify the color by expression if you have more than one measure.