Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspringer
Partner - Contributor
Partner - Contributor

Survey - Relative Ranking

How would I accomplish the following?


I have a dataset that roughly looks like the following:

Question, Company, Value

1, CompanyA, 10000

1, CompanyB, 20000

1, CompanyC, 30000

2, CompanyA, 1

2, CompanyB, 5

2, CompanyC, 11

3, CompanyA, 0

3, CompanyB, 3

3, CompanyC, 12

In the real dataset there are more like 200 companies, not just A, B, C.  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).  Meaning, for Question 1 the highest 20% scores would receive a 5, the next 20% would receive a 4, and so on.  The challenge is that for some questions the higher the better, for others the lower the better.

Thoughts!?

Thank you in advance!

1 Reply
Anil_Babu_Samineni

Some what i understand your intend to prove

If you don't mine, Can you let us know the Expected Result to see for this sample Data

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)