Custom sort in a chart

[samuel_brierley]

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

[alexandros17]

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, ...