Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Blackadder2000
Contributor II
Contributor II

Alphanumeric sorting in Qlik Sense

Hello,

I have a table and a line chart i Qlik Sense where my alphanumeric values are sorted correctly in my table by in a different incorrect way in the line chart. The correct sorting in the table starts with M718C130, M719B130, M720C130, M721B130 etc. The same data in the line chart is sorted according to: M718C130, M736A130, M719B130, M734A130. The data is loaded from a CSV file. I  am unable to sort the line chart data correctly by using Sort numerically or Sort alphabetically. I tried in both Qlik Sense Desktop November 2019 and Qlik Sense Enterprise September 2019.

/Peter

Labels (1)
2 Replies
passionate
Specialist
Specialist

Use minstring function in expression sorting

Blackadder2000
Contributor II
Contributor II
Author

Thanks but could you show an example for this function? =Minstring(variable of interest) does not seem to be sufficient in the sorting skript.