topic Re: Rank in QlikView

Rank

Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 15 Mar 2016 19:51:04 GMT

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

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

sunny_talwar — Tue, 15 Mar 2016 19:52:05 GMT

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

Tue, 15 Mar 2016 19:57:22 GMT

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

MarcoWedel — Tue, 15 Mar 2016 23:09:14 GMT

Hi,

maybe also possible:

Aggr(NODISTINCT Rank(sales),sales)

hope this helps

regards

Marco

engishfaque — Wed, 16 Mar 2016 05:21:44 GMT

Dear Upen,

Kindly find attached App.

Kind regards,

Ishfaque Ahmed

Digvijay_Singh — Wed, 16 Mar 2016 05:49:35 GMT

Vow!

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

Wed, 16 Mar 2016 21:10:20 GMT

thank you so much Marco.. it worked

Awesome

MarcoWedel — Wed, 16 Mar 2016 22:30:43 GMT

you're welcome.

Glad I could help.

regards

Marco