Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
dionverbeke
Luminary Alumni
Luminary Alumni

Change color of measure based on condition with multiple measures

Hi,

Can we change the color of a measure if we have multiple measures, based on a condition?

f.e.:

1 dimension Country

2 measures (Sales and Cost)

 

I want to color sales green or red depending on a condition and cost orange)

if I would have getobjectfield='Sales' that would work, but it does not seem to work for color expressions.

Can someone help if that is even possible?

 

Kind Regards,

 

Dion

 

2 Replies
Anil_Babu_Samineni

Can you try to explain with sample data set, We will look into it?

Are you even fine to use extensions?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
dreweezy
Partner - Creator II
Partner - Creator II

it seems like you want to highlight the cells for a measure field? You can do that by going into the left hand side and setting up a color by expression, measure, etc. If you want to color coordinate values within a measure based on a condition, you will probably do that configuration under the field you want to adjust by adding a conditional format like -->

if ([SALES] > 1000, red(), green()) - This will highlight cells red if sales are greater than 1000 and green vice versa.

Hope this helps.