Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting chart month formula

Hi,

In this chart, dimension=Month (fieldname=Monthname) and measure=Quantity.

Under sorting what would be the expression (formula)? Tried several formulas, cant seem to manage..

Thanks

Qliksmonth.JPG

10 Replies
Anonymous
Not applicable
Author

Hi,

Is "month" the original data you get? If no, and if you have Date column in your original data, always better to get month column using "MasterCalender" script by using the Date (you can find a lot in the community). If "month" is the original info you get, then it is still string/text, can not be recognized as month in QV, that is why it can not be sorted correctly. You need first change it to a real month be recognized by QV. The expression for this is:

Month(Date#(Monthstring, 'MMMM')),

then it can be ordered correctly by using the setting in Sort tab is the chart properties.

And pls notice one trick when using this way, by default, the Month() method only recognizes the month name in the language you select for your QV.

Hope this helps.

Zhihong