Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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, CSmiley Very Happy. 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

Community Browser