topic Survey - Relative Ranking in QlikView https://community.qlik.com/t5/QlikView/Survey-Relative-Ranking/m-p/1247773#M621389 <HTML><HEAD></HEAD><BODY><P>How would I accomplish the following?</P><P><BR />I have a dataset that roughly looks like the following:</P><P></P><P>Question, Company, Value</P><P>1, CompanyA, 10000</P><P>1, CompanyB, 20000</P><P>1, CompanyC, 30000</P><P>2, CompanyA, 1</P><P>2, CompanyB, 5</P><P>2, CompanyC, 11</P><P>3, CompanyA, 0</P><P>3, CompanyB, 3</P><P>3, CompanyC, 12</P><P></P><P>In the real dataset there are more like 200 companies, not just A, B, C.&nbsp; How would I quickly add a new column that would evaluate each response and assign a score of 1-5 depending on their ranking (in relative bands).&nbsp; Meaning, for Question 1 the highest 20% scores would receive a 5, the next 20% would receive a 4, and so on.&nbsp; The challenge is that for some questions the higher the better, for others the lower the better.</P><P></P><P>Thoughts!?</P><P></P><P>Thank you in advance!</P></BODY></HTML> Fri, 10 Feb 2017 00:11:57 GMT sspringer 2017-02-10T00:11:57Z Survey - Relative Ranking https://community.qlik.com/t5/QlikView/Survey-Relative-Ranking/m-p/1247773#M621389 <HTML><HEAD></HEAD><BODY><P>How would I accomplish the following?</P><P><BR />I have a dataset that roughly looks like the following:</P><P></P><P>Question, Company, Value</P><P>1, CompanyA, 10000</P><P>1, CompanyB, 20000</P><P>1, CompanyC, 30000</P><P>2, CompanyA, 1</P><P>2, CompanyB, 5</P><P>2, CompanyC, 11</P><P>3, CompanyA, 0</P><P>3, CompanyB, 3</P><P>3, CompanyC, 12</P><P></P><P>In the real dataset there are more like 200 companies, not just A, B, C.&nbsp; How would I quickly add a new column that would evaluate each response and assign a score of 1-5 depending on their ranking (in relative bands).&nbsp; Meaning, for Question 1 the highest 20% scores would receive a 5, the next 20% would receive a 4, and so on.&nbsp; The challenge is that for some questions the higher the better, for others the lower the better.</P><P></P><P>Thoughts!?</P><P></P><P>Thank you in advance!</P></BODY></HTML> Fri, 10 Feb 2017 00:11:57 GMT https://community.qlik.com/t5/QlikView/Survey-Relative-Ranking/m-p/1247773#M621389 sspringer 2017-02-10T00:11:57Z Re: Survey - Relative Ranking https://community.qlik.com/t5/QlikView/Survey-Relative-Ranking/m-p/1247774#M621391 <HTML><HEAD></HEAD><BODY><P>Some what i understand your intend to prove</P><P></P><P>If you don't mine, Can you let us know the Expected Result to see for this sample Data</P></BODY></HTML> Fri, 10 Feb 2017 01:48:14 GMT https://community.qlik.com/t5/QlikView/Survey-Relative-Ranking/m-p/1247774#M621391 Anil_Babu_Samineni 2017-02-10T01:48:14Z