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: 
danieldors
Contributor III
Contributor III

Target by Work Type

I have  employees grouped  under Work Type, Im trying to color coordinate to show those producing less than the average for their own work type.

 

=if(sum([PPE History.Total Transactions])/sum([Hours Worked])>(sum([PPE History.Total Transactions])/sum([Hours Worked])),Green(),rgb(178,36,36))

 

Thank you.

1 Reply
AdiPai
Creator II
Creator II

You can use the master measure and define colours in the master measure based on segment values

 

AdiPai_0-1610610745386.png