Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Partner
Partner

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
Highlighted

Re: Survey - Relative Ranking

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

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)