Line chart issue

[Rajesh5kumar]

Hi,

I have attached a data set file for this.

I need a line chart having win_date, Top 5 Pl_name(Rank) and avg(time).

sorting of the legends should be as top5-->if same value then alphabetical order but top 5

for ex

P_name  Value

A                158

B              120

C              118

D              118

E               127

F              118

G              98

H             75

then the top 5 should be

A

E

B

C

D

this should be as legends for the line chart

The data is attached and images are also attached.

I want in qvf format 

Thanks in advance 

Regards

Kumar

[Rajesh5kumar]

@sunny_talwar 

I need that only QV#1 is should be in top 5 

The issue was if same value then it should be in alphabetical order

But I need top 5 only in chart as legends 

The table  I made was just a trial for my understanding 

The main thing is I need a line chart

Regards

Kumar

[sunny_talwar]

@Rajesh5kumar I get the point, but in alphabetical order, should QV#1 come before QV#15?

[Rajesh5kumar]

Yes..

So for top 5 the order should be ..

_total

Idle

erl

Notepad

QV#1