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: 
danielnevitt
Creator
Creator

Chart Sort

Hi,

I have a chart where I would like to set the sort to:

OCT-16

NOV-16

DEC-16

JAN-17

etc

Is it possible to pre-set a sort like this?

Thanks,

Daniel

5 Replies
varshavig12
Specialist
Specialist

sunny_talwar

So are you hoping to always get the current Month as the first Month of the sort or is this always Oct based on your fiscal Year? If it is always Oct, you can try this:

Match(Month(Only({1}MonthYearField)), 10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9)

maleksafa
Specialist
Specialist

you can do that in the script by loading the field as dual, the first value will be the date and the second value will be the sort order Year and MonthOrder (201512,201601,201602), and then in the chart you will sort based on numerical value asc.

Anonymous
Not applicable

Try this:

=date(Field_Date,'MMM-YY')

or

data.JPG

Anonymous
Not applicable

The result will be

resultado data.JPG