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

    Ratio of Employee Strength in different Grades




      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.