Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
As a result, I wanna see legend: B1 B2 A1. Same as bars sorting.
Thank you in advance 🙂
Hey !
You can sort your graph by the dimension "Code".
Look this picture :
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
Hi @__Ruta,
you can sort your dimension "Code" with option "Sort alphabetically" to change position of segments of column.
Thanks
Hey,
Thank you for your reply! 🙂
But it's only working with auto colors. I want to have like color gradient according dimension:
Otherwise my graph looks like that:
Ruta
In this case, you can use the sort by alphabetical order.