Custom sort in a chart

samuel_brierley — Fri, 24 Oct 2014 11:27:54 GMT

Hi all, first of all thanks for any help.

I have a dimension that relates to a location (a few examples are listed below), the locations are strings but are sorted numerically as they contain a number. using the Qlikviews built in sorts i am unable to get them in the order I want, is there a way to literally just list them in the sort expression boxy to say put this one first, this one second and so on.

the order QlikView puts them in;

'0:1

'1:39

'2:3

'3:38

the order I would want is;

'0:1

'2:3

'1:39

'3:38

Please dont try and understand the logic behind naming locations like this there is no sense to it what so ever therefore any automatic sorting is impossible.

thanks for any help

Re: Custom sort in a chart

alexandros17 — Fri, 24 Oct 2014 11:35:04 GMT

In the customized sort try to apply your sorting logic in this way:

If(myRange='xxx', 1,

If(myRenge='yyy', 2,

.... and so on

)

in this way there will be a natural sorting with 1, 2, ...

topic Custom sort in a chart in QlikView

Custom sort in a chart

Re: Custom sort in a chart