Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use minstring function in expression sorting
Thanks but could you show an example for this function? =Minstring(variable of interest) does not seem to be sufficient in the sorting skript.