Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-08-21 02:10 PM

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,667 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2017-08-22 09:26 AM
Author

In response to felipedl

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.

238 Views
0 Likes
Anonymous
Not applicable
‎2017-08-22 09:56 AM
Author

In response to sunny_talwar

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

238 Views