Discussion Board for collaboration related to QlikView App Development.
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
maybe also possible:
hope this helps
View solution in original post
Have look at the Help on the QV Desktop for the Rank() function.
You'll see that Rank() has 3 parameters.
Bill but how would you get 2 for jay. I have tried all possible combination, but jay always stay at 3
Bill-> I tried all combinations from help it is not what i wanted. i am getting the same results as Sunny
Kindly find attached App.
I am still trying to understand how Aggr(NODISTINCT Rank(sales),sales) did the magic
thank you so much Marco.. it worked
Glad I could help.