Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Sorting Month's in Qliksense

Hi all,

can any one let me know i want to sort Months.. it should come in this way..

Jan, feb,mar...till............dec.

but in my case it is not coming even by expression

if(Month= 'jan',dual('Month',1),

     if(Month= 'feb',dual('Month',2), and so on

can any one help me in this?

regards

ABhay

5 Replies
preminqlik
Specialist II
Specialist II

sort by expression :

=only({1}num(Month(Date#(Month,'mmm'))))

abhaysingh
Specialist II
Specialist II
Author

Sry prem its not working

preminqlik
Specialist II
Specialist II

try this

=only({1}num(Month(Date(Date#(left(Upper(trim(Month)),3),'MMM')))))

or else post sample app

jagan
Luminary Alumni
Luminary Alumni

Hi Abhay,

Order the dates in the script itself and select Load Order in Sort tab, always use master calendar.  Check this link

Understanding the Master Calendar (video)

ToniKautto
Employee
Employee

I think you need to do two things to accomplish your requirement.

1. Load your data with enumerated month labels

2. Sort the expression by number

This will make your data clearer and the front end work much easier.