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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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')