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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
tresB
Champion III
Champion III

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
tresB
Champion III
Champion III

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

 

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