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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Solution

Accepted Solutions
Nicole-Smith
MVP
MVP

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
MVP
MVP

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!