Discussion Board for collaboration on QlikView Scripting.
I have the attached data - basically its sales data for 300 salesman in 3 regions for 3 different years.
Based on the combined sales figures for all 3 years, I would like to grade the salesmen's performance, first, based on their usa sales, into 5 grades (using fractile).
Then, based on those salesmen that are graded 1 for their usa sales, grade them again based on their asia sales figures (also into 5 categories using fractile).
Then, based on those salesmen that are graded 1 for their usa sales and graded 1 for their asia sales, grade them again based on their europe sales (also into 5 categories using fractile).
Repeat for those that are graded 2 for their usa sales and so on...
After the evaluation, sum all of the grades to produce an overall score. The model structure and envisioned result are as attached.
I have a feeling that it requires a nested loop but have no idea how to do it.
Can anyone help? I'm using a personal edition so I would appreciate if you could show the load script here.