0 Replies Latest reply: Feb 13, 2017 11:35 AM by Itban Omair RSS

    colour by expression in map-qlik sense

    Itban Omair

      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])