Rank function with multiple dimensions

[agigliotti]

Hi,
I'd need to show only the first 3 rows sorted by F1 field desc.
As you can see only the first row for each date is ranked.
In the last column (if....)  I'm checking if the rank is  <= 3 but  it does not work as requested.

The desired result should be as below:

How can I achieve it?

Attached the qvw file

Many thanks in advance for your time.

Best Regards

@rwunderlich  @Digvijay_Singh  @marcus_sommer   @Or  @Lech_Miszkiewicz  @simonaubert   @Chanty4u  @Michael_Tarallo 

[Digvijay_Singh]

Probably you try these parameters in your rank measure, but I don't think you can get 1,2,2,3 sequence, after equal rank you get the next rank skipped, so it would be 1,2,2,4 ranks when 2nd and 3rd items are same 

[Digvijay_Singh]

Don't have qlikview so cannot see your expression..

[agigliotti]

with that expression I get exactly the same result (1,2, -, 3, -, 4,5, -, -)
I need to include also the rows (ggg, eee) with null as rank because its real rank is less or equal to 3.

Someone can help me?

[Digvijay_Singh · Accepted solution]

May be this - 

[agigliotti]

Hi @Digvijay_Singh ,
Great Job, it worked!
Many thanks for your collaboration.
Best Regards