Straight table sort

[Anonymous]

How can I sort a dimension in a straight table alphanumerically?  Currently, it sorts in "natural order" which is not what we need. We have an item number field that contains letters and numbers.  For example, Item number "30A" is ordered before item number "11B".  The application we use is Qlik Sense.  What do I need to order our item numbers in an alphanumeric order using Qlik Sense 3.2?

[kenphamvn]

Hi

In sort property chose "Sort alphabetically"

[Anonymous]

Add the number 110D to your example and you will get

05C

11B

30A

110D

This is incorrect for an alphabetical sort.

Qlik uses a "natural sort", you can lookup information on Natural sort if you are unfamiliar with it.

I am trying to get the field to override Qlik's natural sort option and sort alphanumerically. 

Any help with this is greatly needed. 

[sunny_talwar]

When you add 110D, what do you expect the order of the above 4 numbers to be?

[Anonymous]

I expect the order to be:

05C

11B

110D

30A

[sunny_talwar]

Not the same as what you wanted, but this gives a slightly different sort...

[felipedl]

Hi Ann,

You can use the dual() function, making a new "order" in a way you see fit.

Only problem is, that you would need to specify the numeric order for all the data.

Example:

=ValueList(dual('05C',1),dual('11B',2),dual('110D',3),dual('30A',4))

Gives the following as it's ordered by the new numeric representation.

[sunny_talwar · Accepted solution]

This seems like the right sorting (when used descending) based on what I found here:

The Alphabetizer sorts any list in alphabetical order...and much more!‌

[Anonymous]

I will look into the rank() function and let you know if it's what we need.

It looks interesting.  Thank you, I'll get back.

[sunny_talwar]

Sounds good