11 Replies Latest reply: Aug 22, 2017 9:56 AM by Ann Hoffman

# Straight table sort

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?

• ###### Re: Straight table sort

Hi

In sort property chose "Sort alphabetically"

• ###### Re: Straight table sort

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.

• ###### Re: Straight table sort

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

• ###### Re: Straight table sort

I expect the order to be:

05C

11B

110D

30A

• ###### Re: Straight table sort

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

• ###### Re: Straight table sort

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!

• ###### Re: Straight table sort

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.

• ###### Re: Straight table sort

Sounds good

• ###### Re: Straight table sort

Sunny,

Thank you so much!!  This is exactly what we needed for an alphanumeric sort.

In the tables' Sorting properties, I checked the box "Sort by expression" then I used the expression =rank(itemID)

and it works perfectly!

Thank you again.

Ann

• ###### Re: Straight table sort

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.

• ###### Re: Straight table sort

I cannot use the method of a dual() function in my scenario because the number I'm sorting on is our Item ID and we have thousands of Item ID's.