Rank

[#1]

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

[Anonymous]

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

[#4]

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

[MarcoWedel · Accepted solution]

Hi,

maybe also possible:

Aggr(NODISTINCT Rank(sales),sales)

hope this helps

regards

Marco

[engishfaque]

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

[#8]

thank you so much Marco.. it worked

Awesome

[MarcoWedel]

you're welcome.

Glad I could help.

regards

Marco