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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
rsimson1
Contributor II
Contributor II

Change the month order in a chart from Jan - Dec to Aug - July

Hi,

Can someone please indicate a simple was of displaying the chart below starting with the the month of August to July instead of January to December?. Can this be done in the chart or must it be done in the script?

Chart 1.png

10 Replies
swuehl
MVP
MVP

Chanty 4u wrote:

SET MonthNames= 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul';

I think this would result in creating text representation 'Aug' for January Dates, won't it?

= Month(Makedate(2016,1,1))