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: 
Not applicable

How to arrange Month as per the calendar?

Hi Folks,

I have a columns like Month and Sales.

I created a Bar Chart and now i am unable to show as " Jan,Feb,Mar...Dec".

I got the same in Qlikview, but not get in QlikSense.

Any one can suggest me..

@Sub2u444

5 Replies
Chanty4u
MVP
MVP

tamilarasu
Champion
Champion

You can try sort expression as =Month(Date#(Month,'MMM'))

tresesco
MVP
MVP

Possibly you have not created the Month field using Month(). Try to correct it at the script, like:

Load

          Month(Datefield) as Month

then it should get sorted as you desired by default.

vikasmahajan

Create Field in calendar and sort on this

If(Num(Month(DateField))>3,Num(Month(DateField))-3,Num(Month(DateField))+9) AS MonthNumber,

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
luciancotea
Specialist
Specialist

In script you need to create the Month field as DUAL. Show text but sort by number. See Dual() in help.

Dual(month(MyDate), monthstart(MyDate)) as MyMonth