How to sort calendar month in sequential order like Jan,feb,march from 2015 to 2017 year in listbox in qliksense. plz help me out in this .

[dathathreya]

How to sort the month in list box like jan 2015,feb 2015 to jan 2017 in qlik sense.

[MK_QSL]

Create Month Year as below in Script

Date(Floor(MonthStart(DateField)),'MMM YYYY') as MonthYear

and use MonthYear as List box or filter..

[viveksingh]

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 ?

[viveksingh]

use like

Date(Timestamp(DATE FIELD),'MMM-YYYY')

[dathathreya]

Its not working it is showing random values

[MK_QSL]

Show us how you have created Month Year field.

[dathathreya]

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

[dathathreya]

i am not able to attach qvf file

[sunny_talwar]

Try this

Date(MonthStart(Date#(Month_Year,'MMM_YYYY'))) as Month_Year

Date(MonthStart(Date#(Month_Year,'MMM-YYYY'))) as Month_Year

[dathathreya]

It is also not working.i have used this expression in filter panel -sorting-in expression