0 Replies Latest reply: Nov 14, 2011 11:54 PM by shekhar.rashi RSS

    Ratio of Employee Strength in different Grades

       

      Hi,

       

      I am trying to create a bar chart where I want to find the ratio of employee strength in different grades.

       

      The Grades are ranging from A - D. The employees, who have different employee number, are given a grade ranging from A to D. What I need to show is the ratio of employee strength in each grade and its next grade. The X axis should have the ratio of consecutive grade names, i.e., A:B, B:C, C:D. The Y axis should contain the values of the same, i.e., count( Employee with Grade = 'A') / count( Employee with Grade = 'B') and so on. I have attached a qlikview file explaining my requirement.

       

      Kindly help me.

      Regards,
      Rashi