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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort months in a graph logically

Guys,

I created the following graphScreenshot_2.png

It works fine but I want to sort it logically (jan - feb - mar - apr etc...)

Screenshot_3.png

There I tried to sort it by the month column (2_Maand).

But this does not seem to work. Any thoughts how I can sort it more logically?

Labels (1)
1 Reply
oknotsen
Master III
Master III

Assuming you months are a result of the month() function (so not simple text), I suggest turning off the "sort on Y-value" as that effectively means sort on expression and turn on "sort on Numeric Value" as months are secretly the number 1-12.

May you live in interesting times!