Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## 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?

1 Solution

Accepted Solutions
MVP

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

11 Replies
Creator III

Hi

In sort property chose "Sort alphabetically"

Anonymous
Not applicable
Author

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.

MVP

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

Anonymous
Not applicable
Author

I expect the order to be:

05C

11B

110D

30A

MVP

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

Partner - Specialist III

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.

MVP

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

Anonymous
Not applicable
Author

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.

MVP

Sounds good

Community Browser