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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort Month in Dimension of a Bar Chart

Hi ,

I am creating a simple Bar chart and i am sorting Month Dimension By Numeric value in Sort tab but in output i am getting Dec before Nov and other values are correctly aligned on X axis.

Please let me know how can i fix this .

Thanks,

Prince Panghal

2 Replies
tresesco
MVP
MVP

If your month field is a text field, you could sort using expression like:

=Month(Date#(MonthField, 'MMM'))

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Hi,

Refer attached to sort via a loaded column in script.

Thanks and regards,

Arthur Fong