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   and @Anil_Babu_Samineni

And all other experts

Please respond

It's urgent

Regards

Kumar

[Chanty4u]

try below 

Dimension  = =aggr(if(rank(sum(Value))<=5,PName),PName) // suppress nulls, sort by sum(Value) Ascending
Expression  = sum(Value)

[Rajesh5kumar]

First of all Thanks for responding so quickly..

But this didn't work 😔

Can you send me the qvf

Because I tried but it didn't work

Regards

Kumar

[Rajesh5kumar]

@sunny_talwar  Can you please help me out with the solution

[sunny_talwar]

I might be wrong, but not entirely sure if we can sort the legend. @Kushal_Chawda do you have an idea if legend can be sorted in Qlik Sense?

[Rajesh5kumar]

@sunny_talwar  Legends can be sorted I tried but I could not achieve even after sorting.

Do you have any other idea to solve it.

Sorry to bother you again and again 😞

But the solution is urgently required I tried, asked my peers but they too could not 😞

Regards

Kumar

[sunny_talwar]

@Rajesh5kumar if this is as urgent as your suggest, why don't you load the data in a qvf for us and create the chart where we can see what you have and take it forward from  there... this might be more time efficient. because I don't want us to waste time on working on something which might be 2 second thing for you.

[Rajesh5kumar]

Hi @sunny_talwar ,

I have attached the qvf i want the chart in the same format as table --the legends of the chart should be as arranged in the table

Regards

kumar 

[sunny_talwar]

Qv#1 is also ranked the same, why not include QV#1 instead of QV#15?