Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajesh5kumar
Contributor II
Contributor II

Line chart issue

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

 

Labels (2)
12 Replies
Rajesh5kumar
Contributor II
Contributor II
Author

@sunny_talwar   and @Anil_Babu_Samineni

And all other experts

Please respond

It's urgent

Regards

Kumar

Chanty4u
Champion III
Champion III

try below 

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

Rajesh5kumar
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

@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. @Kush do you have an idea if legend can be sorted in Qlik Sense?

Rajesh5kumar
Contributor II
Contributor II
Author

@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
Contributor II
Contributor II
Author

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?