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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MRitter
Employee
Employee

Sort Challenge

I had to extract some data out of excel.  My field is made up of the full month name and the year.

When I use this field as a dimension I want it to sort correctly by year and then by month within year.  

I have tried 10 different things and nothing has worked so far.  

I probably could go  back to the load script and load the month number instead of the full name.  But at this point I am curious as to how I can work with what I already have.

Thanks

2 Replies
skamath1
Creator III
Creator III

I will create a dual field.  

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunc...

dual(MonthYear, YearMonth)

Below is the sample data

MonthYear, YearMonth
January-2019, 201901
Febuary-2019, 201902
..
..
..



jerifortune
Creator III
Creator III

In addition to the above solution, sort by numerical YearMonth.