Hi,
I am using qliks sense map (area map)in my App. the requirement is to color- different area of map on the basis of measures.
-maximum employees who have completed the course should be green.
-employees count between maximum and 100 should be yellow/orange
-and employee count less that 100 should be red.
I have used color by expression with formulae. can you help in achieving above by tweaking this one.
if(count({<[Course User Status]={'Completed'}>}DISTINCT([EmployeeID]))>200,Green()
Dimension: region name
Measure: employeeid(count({<[Course User Status]={'Completed'}>}DISTINCT([EmployeeID])