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?

[Anonymous]

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.

[Anonymous]

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