Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try below
Dimension = =aggr(if(rank(sum(Value))<=5,PName),PName) // suppress nulls, sort by sum(Value) Ascending
Expression = sum(Value)
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
@sunny_talwar Can you please help me out with the solution
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?
@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
@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.
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
Qv#1 is also ranked the same, why not include QV#1 instead of QV#15?