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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Sort expression on bar chart

I have  bar graph grouped by the field 'commenced quarter'.

The quarters are July-Sept 2019, Oct-Dec 2019, Jan-March 2020.

How do I create an expression to sort the grouping to the above order? It is currently in the order July-Sept 2019,  Jan-March 2020, Oct-Dec 2019. 

 

Thank you 

 

 

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Assuming all your month reference would be of MMM format (three-letter), you could try like:

 

=Date#(QtrField, 'MMM-ZZZ YYYY')

View solution in original post

1 Reply
tresesco
MVP
MVP

Assuming all your month reference would be of MMM format (three-letter), you could try like:

 

=Date#(QtrField, 'MMM-ZZZ YYYY')