Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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