topic Re: Sorting 'Others' Field in a chart in QlikView

Sorting 'Others' Field in a chart

Wed, 05 Mar 2014 12:10:54 GMT

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

Re: Sorting 'Others' Field in a chart

Wed, 05 Mar 2014 12:55:11 GMT

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

Re: Sorting 'Others' Field in a chart

Wed, 05 Mar 2014 13:33:58 GMT

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

Re: Re: Sorting 'Others' Field in a chart

Nicole-Smith — Wed, 05 Mar 2014 15:49:57 GMT

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.

Re: Sorting 'Others' Field in a chart

Mon, 10 Mar 2014 07:50:41 GMT

That worked! Thanks!