2 Replies Latest reply: May 31, 2016 12:17 PM by Kaushal Kant RSS

    Count expression on Qlik Sense - Help needed

    Kaushal Kant

      I am trying to get the count of employee, who are above or below the average / median salary. However getting some challenges.

       

      Have tried these: Count(if([CTC (USD)] < Avg(Total [CTC (USD)]),[Employee Name]))

       

      But the challenge is that the Average is getting calculated for entire population, which is giving the wrong analysis. Data has all job levels and when I draw graph at job level, average should be calculated individual job levels. Comparing salary with lower job level with higher is not the right way.

       

      Have attached the dummy data. Please help.