Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
use like
Date(Timestamp(DATE FIELD),'MMM-YYYY')
Its not working it is showing random values
Show us how you have created Month Year field.
Month_Year is Field in my Data set .i want to sort that in filter pane in qliksense.
now it is like
Mar-2015
Apr-2015
Aug-2015
Dec-2016
Oct-2016
may-2017
like that
I want it like
Jan-2015
to
Dec-2015
Jan-2016 to Dec-2016
Jan-2017
to Dec-2017
i am not able to attach qvf file
Try this
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