How to sort like Excel in Qlik Sense and QlikView

[Mukhiddin]

Cannot sort field values in Qlik Sense/QlikView like in Excel. For instance, we have the following field values:

A1 ,A10, A100, A2, A3, B1

In Excel it is sorted as below:

 

 

 

 

 

However, in Qlik Sense, it is sorted in the following order:

 

 

 

 

 

 

 

Environment

• Qlik Sense, any version
• QlikView, any version

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Workaround

Sorting like Excel in Qlik Sense\QlikView can be accomplished by selecting "Sorting by expression" option and defining the following expression(based on above-mentioned example data):

=index(concat({1} TOTAL distinct ItemName,'-'),ItemName)

Expected Excel sorting in Qlik Sense\QlikView is achieved as follows:

[QlikQlaker]

How can we do that with longer values?! 

I would like the numbers to come before the letters, and the J10 before the J17  before the J18

[Sonja_Bauernfeind]

Hello @QlikQlaker 

I would recommend posting this question over in the Qlik Sense App development forum.  You will have access to our active community and support agents monitoring our forums.

All the best,
Sonja