How can we sort with String value "JAN-22 to JUN-22" by expression in Qlik?

[DJ21]

Wanted to create line graph with monthly analysis of data with MMM-YY but it is not working with. Kindly help to sort data with expression in Qlik.

JAN-22, FEB-22, MAR-22, APR-22, MAY-22, JUN-22

[kaushiknsolanki]

Convert the text into the dates and then sorting will happen automatically.

Try the below expression in the script.

Date(Date#(FieldName,'MMM-YY')) as New_FieldName

[DJ21]

  

[DJ21]

This solution is not working

[kaushiknsolanki]

This has to be written in the script editor and not in the chart expression.

[DJ21]

Hello, Thank you for clarification.
But How to write in script editor. Please find screen shot. This is showing error.

 

[kaushiknsolanki]

It has to be in the load statement and not as a variable. from where is your TImeline field coming?

[DJ21]

Not working. Please find data load new column.

 

[Sujy15 · Accepted solution]

Hi @DJ21 ,

If your primary sorting is based on "Timeline" field contains (MMM-YY) then try using the expression given by @kaushiknsolanki  in Sorting section.

Sorting - > Custom (Sorting) - > check Sort by expression - > and give the expression as Date(Date#(FieldName,'MMM-YY'))

Sample Data Output:

Hope it may helps you!

Thanks!