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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting 'Others' Field in a chart

Hi,

I have been trying to sort my 'Others' field in my chart as the last bar, but I haven't been able to do it in any way. Could anyone help me?

Greetings,

Lucas

1 Solution

Accepted Solutions
Nicole-Smith

Have a look at the Sort tabs on each of the charts in the attached.  I've added a sort by expression that sorts the Others value as last.  The expressions looks like this:

=aggr(count(Customer),[SLS Organization])

where the dimension for the aggr() function is the dimension on the corresponding chart.

View solution in original post

4 Replies
Not applicable
Author

As far as I am aware, the others bar automatically sorts as the last one. Are you applying some other type of sorting and still want the 'others' to appear last? If so, please upload a sample and I will have a look at it for you

Cheers,

Byron

Not applicable
Author

Hi Byron,

I am not using any type of sorting. I even tried removing the sorting properties in the document settings, but it still shows at a random position in the chart.

Greetings,

Lucas

Nicole-Smith

Have a look at the Sort tabs on each of the charts in the attached.  I've added a sort by expression that sorts the Others value as last.  The expressions looks like this:

=aggr(count(Customer),[SLS Organization])

where the dimension for the aggr() function is the dimension on the corresponding chart.

Not applicable
Author

That worked! Thanks!