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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Breezy
Creator II
Creator II

X-axis labelling order?

Hi, my x-axis is alphabetical. However, I'd like to move "FF" to the end. Is there a way to do that? 

 

Breezy_0-1680203362859.png

 

Labels (2)
3 Replies
sandeep-singh
Creator II
Creator II

Try this:

Edit sheet- select your bar chart -> sorting

You will find your measure down below the dimension -> move the measure to the top

then sort numerically -> Ascending

sandeepsingh_0-1680316743170.png

 

 

Breezy
Creator II
Creator II
Author

Unfortunately that did not work. I have one dimension and two measures. I went to 'Sorting' and moved the measures above dimension and then tried Sorting numerically. Now the order is rather messesd up. 

vinieme12
Champion III
Champion III

Under Sorting:

Move the Dimension up the order(above measures)

Enable Sorting Only on the Dimension

Disable sorting on both the measures

 

You can also define custom sorting using a measure expression

choose sort by Expression on the Dimension and try below expression

=Wildmatch(FieldName,'r1','r2','r3','ff')

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.