Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to reverse the order of the legend on a bar chart? When using Stacked bars, my boss would like it to follow the same Top Down order of the stack. I'm using Sense Desktop.
Thanks
Can't you do that in the property -> sort?
In the Sorting section of properties, I can sort by dragging the 'measures' but that also reorders the Bar stack and leaves me with the same issue.
Sort by dimension, uncheck "Auto" sorting, check "Sort by expression", then make the expression descending sorted like this:
That seems to only sort the Bars, and not the stack within the bars.
Does anyone know of any extensions that deal with the Legend? Maybe my answer lies in there somewhere.
No can do, out of the box, as far as I am aware.
You could write an extension, but unless you have extension writing skills that may not be a viable option. Not aware of any suitable open source extensions but worthwhile checking out Qlik Branch
apply sorting expression to 2nd dimension which is forming stack
Hi qmiadmin if you want to reorder the legends we cant sort it directly, so kindly create a Inline table of the dimensions you want to sort giving it a serial number and in sort kindly select sort by Expression and call that field in it. Go through the below images and try the same
Tab1:
Load * Inline [
CustomerName, Sr.No.
Ravi, 1
Kumar, 2
rajesh, 3
kamal, 4
Suresh, 5
];
and in the chart go to sort and select sort by expression
Hi Priyanka
I can't figure out how or where to add the Inline Table. Can you point me in the right direction?
EDIT:
Ok I figured out how to add an Inline Table. Now I just need to figure out how to use it.