Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Employee
Employee

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
];