topic Sort months in a graph logically in QlikView

Sort months in a graph logically

Thu, 19 Nov 2015 13:41:30 GMT

Guys,

I created the following graph

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

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?

Re: Sort months in a graph logically

oknotsen — Thu, 19 Nov 2015 15:55:18 GMT

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.