Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Write Table now available in Qlik Cloud Analytics: Read Blog
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: 
bellesol
Creator
Creator
‎2021-03-09 04:15 AM

Sort numeric values and text values.

Hi,

I need to sort one dimension in a table that contains both numeric values and text values.

I have the following numbers and text value:

HBM24203
HBM24438
1131
1112
HBM24518
HBM24507
HBM24451
1170
1162
1161
1153
1151
1122
1117
1115
HBM24120
HBM24119
HBM24109
HBM24098
HBM24050
HBM24248
HBM24219
HBM24214
1142
1141
1135
1132
1114
1125
1123
HBM24142
1143
HBM24047
1148
1144
HBM24297
HBM23994
HBM24331

 

I would like to sort like this:(first sort by numbers and then by text):

1112
1114
1115
1117
1122
1123
1125
1131
1132
1135
1141
1142
1143
1144
1148
1151
1153
1161
1162
1170
HBM23994
HBM24047
HBM24050
HBM24098
HBM24109
HBM24119
HBM24120
HBM24142
HBM24203
HBM24214
HBM24219
HBM24248
HBM24297
HBM24331
HBM24438
HBM24451
HBM24507
HBM24518

 

 

1,130 Views
0 Likes
2 Replies
Chanty4u
MVP
MVP
‎2021-03-09 04:45 AM

Hi

Chanty4u_0-1615283109988.png

 

1,100 Views
0 Likes
Taoufiq_Zarra
MVP
MVP
‎2021-03-09 04:54 AM

Taoufiq_Zarra_0-1615283691395.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
1,088 Views