Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
sureshqv
Esteemed Contributor III

Re: How to arrange Month as per the calendar?

Re: How to arrange Month as per the calendar?

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

MVP
MVP

Re: How to arrange Month as per the calendar?

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
Honored Contributor III

Re: How to arrange Month as per the calendar?

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

luciancotea
Valued Contributor

Re: How to arrange Month as per the calendar?

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

Community Browser