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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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