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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
phcaptjim
Creator
Creator

Compare dimension total to row total

Hi, I want to compare the dimension total for each 'manager' to each employee to set the background color of the cell.  If the employee is better than or equal to the average, i want to shade the cell green, otherwise shade the cell red.  I know this is a simple task but I cannot figure it out.

Here is an example of what I hope to accomplish:

qvw.jpg

Any ideas?

Thanks!

0 Replies