Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
__Ruta
Contributor II
Contributor II

Bar chart legend dimension sorting

Hi, 

I have an inline table:

LOAD * INLINE [
ID, Code, Quantity, Rating
1, B1, 15, 1
1, B2, 20, 2
1, A1, 12, 3
2, B2, 20, 2
3, A1, 10, 3
];

I created a bar chart with stacked dimension and sorted by 'Rating' dimension. So, the table is well sorted, but the legend is automatically sorted according to the alphabet. (The colors are selected according to the dimension [Code])

__Ruta_1-1724662583828.png

As a result, I wanna see legend: B1  B2  A1. Same as bars sorting.

Thank you in advance 🙂

Labels (4)
4 Replies
theoat
Partner - Creator III
Partner - Creator III

Hey !
You can sort your graph by the dimension "Code".
Look this picture :
Capture d'écran 2024-08-26 123138.png

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

gomeri
Partner - Creator
Partner - Creator

Hi @__Ruta,

you can sort your dimension "Code" with option "Sort alphabetically" to change position of segments of column.

gomeri_0-1724668943987.png

 

Thanks

Giovanni O. D.
__Ruta
Contributor II
Contributor II
Author

Hey, 

Thank you for your reply! 🙂

But it's only working with auto colors. I want to have like color gradient according dimension:

__Ruta_0-1724669140621.png

Otherwise my graph looks like that:

__Ruta_2-1724669193003.png

Ruta

 

 

 

theoat
Partner - Creator III
Partner - Creator III

In this case, you can use the sort by alphabetical order.

Capture d'écran 2024-08-26 141421.png