Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank Issue

Hi Team,

I have attached an image with Rank function implemented for EmpID and their respective Salary.

Test.JPG

There are 4 Employes which have the same salary and Ranked as 4-5 and 8-9.

Now if I Group the Ranks into A & B, so that I can give different Ranks (i.e. the same salary gets divided into two groups) to the same salaries of different employees.

Kindly assist me implementing the same, using Rank function (without sorting)

EmpID, Salary, Rank, Group

Annie    8500    1,    A

Proj    7000    2,    A

Pith    6500    3,    A

Rossel    5000    4-5,  A

Zen    5000    4-5,  A

Richie    4500    6,    A

Paul    3000    7,    A

Rahim    2000    8-9,  A

Reshma    2000    8-9,  B

Rose    1000    10,   B

Thanks in advance

10 Replies
avinashelite

if you have got the answer mark the correct answer  and close this thread