Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
Specialist
Specialist

Use minstring function in expression sorting

Highlighted
Contributor
Contributor

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