Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Nested loop for grading

Hi

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.

Thanks!!

Community Browser