Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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
Contributor III
Contributor III

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.