topic Nested loop for grading in QlikView https://community.qlik.com/t5/QlikView/Nested-loop-for-grading/m-p/1090119#M640961 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have the attached data - basically its sales data for 300 salesman in 3 regions for 3 different years.</P><P></P><P>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).</P><P></P><P>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).</P><P></P><P>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).</P><P></P><P>Repeat for those that are graded 2 for their usa sales and so on... </P><P></P><P>After the evaluation, sum all of the grades to produce an overall score. The model structure and envisioned result are as attached.</P><P></P><P>I have a feeling that it requires a nested loop but have no idea how to do it.</P><P></P><P>Can anyone help? I'm using a personal edition so I would appreciate if you could show the load script here.</P><P></P><P>Thanks!!</P></BODY></HTML> Fri, 04 Mar 2016 04:12:14 GMT 2016-03-04T04:12:14Z Nested loop for grading https://community.qlik.com/t5/QlikView/Nested-loop-for-grading/m-p/1090119#M640961 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have the attached data - basically its sales data for 300 salesman in 3 regions for 3 different years.</P><P></P><P>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).</P><P></P><P>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).</P><P></P><P>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).</P><P></P><P>Repeat for those that are graded 2 for their usa sales and so on... </P><P></P><P>After the evaluation, sum all of the grades to produce an overall score. The model structure and envisioned result are as attached.</P><P></P><P>I have a feeling that it requires a nested loop but have no idea how to do it.</P><P></P><P>Can anyone help? I'm using a personal edition so I would appreciate if you could show the load script here.</P><P></P><P>Thanks!!</P></BODY></HTML> Fri, 04 Mar 2016 04:12:14 GMT https://community.qlik.com/t5/QlikView/Nested-loop-for-grading/m-p/1090119#M640961 2016-03-04T04:12:14Z