Rank function within FieldValue

[tajmohamed30]

Hi Qlikees,

How can I find 1st 3 positions of each customer in customer column by Sales.

Example

Person	Sales
A	100
B	547
C	541
D	624
E	547
B	214
A	569
C	547
D	214
D	632
A	845
A	624
B	854
B	124
B	365
C	215
D	847
C	621
D	321
C	874

Output: Display top 3 by each same person also is there a way to choose topers seperately like only list of 2nd / 3rd / 1st.

Person	Sales
A	845
A	624
A	569
B	854
B	547
B	365
C	874
C	621
C	547
D	847
D	632
D	624

Your help much appreciated in community.

Regards

Taj Mohamed

[antoniotiman · Accepted solution]

Hi,

See Attachment.

Regards,

Antonio

[tajmohamed30]

Thank you Antonio Mancini

This is what exactly I'm looking for, hence closing this dicsussion.

Regards

Taj Mohamed

[Anil_Babu_Samineni]

You can use simply this after generating the Key

If(Rank(Sum(Sales)) <= 3, Sum(Sales))