Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
user467341
Creator II
Creator II

Sorting bar chart legend?

Hi. I have issue trying to sort my bar chart legend.

The current legend is

100

300

250 (New)

260 (Old)

Others

How can I sort the above into:

100

250 (New)

260 (Old)

300

Others

TIA

 

Labels (1)
  • Chart

2 Replies
jochem_zw
Partner Ambassador
Partner Ambassador

You can Make them Dual values. 
so dual(‘100’,1) dual(‘250 ( new)’,2) dual(‘300’,4) etc. So it will be sorted by numeric values 

anat
Master
Master

if above values are static you can also create inline table then use Bucket_order field for sort.

make sure first field should be same in both tables.

 

Inline:
LOAD * Inline [
Bucket,Bucket_order
100,1

250 (New),2

260 (Old),3

300,4

Others,5
];