Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to sort Legend in Line Chart Qlik Sense?

Hi All,

ask-01.png

I have 2 dimensions (date, region) and 1 measures (sales), in legend seen REGION 4, REGION 3, REGION 5, REGION 1, REGION 2

But I want to sort by value of sum sales desc (REGION 4, REGION 2, REGION 5, REGION 3, REGION 1)

Anyone can help me?


Previously I have been looking for similar thread but I did not get a solution.

Thanks

Regards,

Agus Irawan

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

To change sorting you need to uncheck "Use Continuous Scale" from X Axis Properties..

PFA

View solution in original post

4 Replies
Highlighted
Partner
Partner

To change sorting you need to uncheck "Use Continuous Scale" from X Axis Properties..

PFA

View solution in original post

Highlighted
Not applicable

Thank you Shraddha, your answer is very helpfull.

Highlighted
Partner
Partner

That solution works, but not if you want to keep your x axis a continuous scale.

To anyone who has this problem, searched for it and ended out in this thread, I found the solution here: https://support.qlik.com/articles/000049105 Basically you need to turn of the 'Auto' Colors in the 'Colors and Legend' properties of the chart and change it to 'By Dimension'.

Highlighted
Explorer II
Explorer II

Thank you so much for posting this, I've been scouring the web for way to get my legend to appear in the correct order, I will post my searches here so that hopefully it brings it to the top of Google searches for others:

How to sort the legend in Qliksense?

How to sort the legend in Qliksense in alphabetical order?

How to sort legend in stacked bar chart Qliksense?

 

For context my legend is: 'A) $0 Incurred', 'B) $1 - $5,000', 'C) $5,000 - $25,000', 'D) $25,000 - $50,000', 'E)$50,000 - $100,000', 'F) $100,000 - $250,000', 'G) >$250,000'