Discussion board where members can get started with Qlik Sense.
How to sort the month in list box like jan 2015,feb 2015 to jan 2017 in qlik sense.
Create Month Year as below in Script
Date(Floor(MonthStart(DateField)),'MMM YYYY') as MonthYear
and use MonthYear as List box or filter..
concat year with Month and rename it as new Field and use the new field.
or else use load order. if you remove check option for Sort by Expression, Sort by Numerical, Sort by alphabetical it will automatically loads load order.
or else you have to write an expression.
if possible, Can you post me your sample QVF ?
Month_Year is Field in my Data set .i want to sort that in filter pane in qliksense.
now it is like
I want it like
Jan-2016 to Dec-2016
Date(MonthStart(Date#(Month_Year,'MMM_YYYY'))) as Month_Year
Date(MonthStart(Date#(Month_Year,'MMM-YYYY'))) as Month_Year
It is also not working.i have used this expression in filter panel -sorting-in expression