Discussion Board for collaboration related to Qlik Education.
I have a line chart in my dashboard, it contains date like Jan-11,Feb-10.....
I am not able to sort the dates. I want the dates to be look like Dec - 12, Jan - 13, Feb - 13,.............
Go to Solution.
In sort tab you can promote to first your YearMonth field..
then apply in your Expression
In sort option write
Or if you have Monthname field use that remove any sort option from sort option
Go to Sort Tab
Write Below in your Expression
Thanks Anand & Manish.
Both ways did not work, it is sorting but not in order.
Note, my YeatMonth data in Excel ( Dec - 12 ), ( Jan - 13 ), ............. are in text format !
Then try this way
=Date#(date,'MMM - YY') //in sort order or remove all other sort option if selected
But if possible make another in the load script as
MonthName(Date) as MonthYear
Thanks Anand, but your explanation is not so clear for me, could you explain further!
I have applied your steps, did not work!
I suggested for particular field not for all rows and for that field you have in the data model
MonthName(date) as MonthYear
Date#(date,'MMM - YY') as MonthYear
To convert MonthYear to proper date field is important if you use it as sorting you can do this in front end also but there you may get performance issue.
Did not work.
Your steps are Not clear .
Kindly explain in more detailed steps.Thanks