Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

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
Valued Contributor II

Re: Sorting Month's in Qliksense

sort by expression :

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

abhaysingh
Contributor III

Re: Sorting Month's in Qliksense

Sry prem its not working

preminqlik
Valued Contributor II

Re: Sorting Month's in Qliksense

try this

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

or else post sample app

MVP
MVP

Re: Sorting Month's in Qliksense

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)

Employee
Employee

Re: Sorting Month's in Qliksense

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.

Community Browser