Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Creator II
Creator II

Sorting - month name

Hi!

I have a bar chart with the names of the month on the x-axis.

What is the easiest way to sort them (names) so that the current month is at the end of the chart on the right and the rest in succession?

AprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarch

In April:

MayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchApril

etc.

 

Labels (3)
12 Replies
qlikeers
Creator II
Creator II
Author

=IF(num("MonthName")-month(Today())>0,num("MonthName")-month(Today()),12+num("MonthName")-month(Today()))

Or
MVP
MVP

Same formula, then, just add +1 to the inner structure to push every month one step up the line.

qlikeers
Creator II
Creator II
Author

Thanks for help!