Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
deerhunter
Creator
Creator

Calculate & Compare Actual/Mean & coloring table value based on results

Qlik Sense: November Release - Desktop Version


I have attached a sample App, Can anyone please fix my challenge i fear that i have been looking at it too long to see the issue. Thank you in advance!


Problem:

1) I'm trying to show the Mean Value by Category Type. I don't think this is correct as coded in the table example included

2) Across Category Key and Category Type, I want to compare the Actual Value to the Mean Value and color the TEXT Actual Values RED for those results that are greater the Mean. And Green for those that are less than the Mean.

Labels (1)
1 Reply
Anonymous
Not applicable

In the attached I have created a new Sheet called Test Bill, is the table at the bottom of that sheet what you are after ?