Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month order

hi

i am trying to show monthly statistics but i can't get the moths in order the chart is displayed like the image which i have shown below..

how can i get the correct order??

ex; Jan , Feb ,Mar, Apr, May... etcUntitled.png

thank you in advance

12 Replies
Not applicable
Author

i have attached the Excel sheet also

ashfaq_haseeb
Champion III
Champion III

Hi use this expression

=match(Month, 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep', 'Oct', 'Nov', 'Dec') for sorting.

It works.

Regards

ASHFAQ

Not applicable
Author

It worked thank you soooo much... really appreciate your help