Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Creator II
Creator II
‎2021-03-15 06:55 AM

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 (1)
Labels
6,656 Views
0 Likes
12 Replies
qlikeers
Creator II
Creator II
‎2021-03-16 07:23 AM
Author

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

6,519 Views
Or
MVP
MVP
‎2021-03-16 08:45 AM

In response to qlikeers

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

1,035 Views
qlikeers
Creator II
Creator II
‎2021-03-16 10:09 AM
Author

Thanks for help!

1,019 Views
0 Likes