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: 
Not applicable

Rank

Name    sales     rank

drew       100          1-2

ben          100          1-2

jay             99           3

I am getting this result when i use rank function. Is there a way where i get drew and ben's rank as 1 and jay Rank  as 2

Thanks in advance

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe also possible:

Aggr(NODISTINCT Rank(sales),sales)

QlikCommunity_Thread_209626_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

8 Replies
Anonymous
Not applicable
Author

Have look at the Help on the QV Desktop for the Rank() function.

You'll see that Rank() has 3 parameters. 

sunny_talwar

Bill but how would you get 2 for jay. I have tried all possible combination, but jay always stay at 3

Not applicable
Author

Bill-> I tried all combinations from help it is not what i wanted. i am getting the same results as Sunny

MarcoWedel

Hi,

maybe also possible:

Aggr(NODISTINCT Rank(sales),sales)

QlikCommunity_Thread_209626_Pic1.JPG

hope this helps

regards

Marco

engishfaque
Specialist III
Specialist III

Dear Upen,

Kindly find attached App.

Kind regards,

Ishfaque Ahmed

Digvijay_Singh

Vow!

I am still trying to understand how Aggr(NODISTINCT Rank(sales),sales) did the magic

Not applicable
Author

thank you so much Marco.. it worked

Awesome

MarcoWedel

you're welcome.

Glad I could help.

regards

Marco