Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
dathathreya
Creator
Creator

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 .

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

13 Replies
MK_QSL
MVP
MVP

Create Month Year as below in Script

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

and use MonthYear as List box or filter..

viveksingh
Creator III
Creator III

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
Creator III
Creator III

use like

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

dathathreya
Creator
Creator
Author

Its not working it is showing random values

MK_QSL
MVP
MVP

Show us how you have created Month Year field.

dathathreya
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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