Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dionverbeke
Luminary
Luminary

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
dreweezy
Partner
Partner

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.