Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

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
Highlighted
MVP
MVP

Re: 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 .

Create Month Year as below in Script

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

and use MonthYear as List box or filter..

Highlighted
Contributor II

Re: 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 .

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 ?

Highlighted
Contributor II

Re: 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 .

use like

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

Highlighted
Contributor

Re: 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 .

Its not working it is showing random values

Highlighted
MVP
MVP

Re: 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 .

Show us how you have created Month Year field.

Highlighted
Contributor

Re: 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 .

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

Highlighted
Contributor

Re: 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 .

i am not able to attach qvf file

Highlighted

Re: 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 .

Try this

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

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

Highlighted
Contributor

Re: 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 .

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