How ordenate the months in Qlik?

[Natalie]

In my application the months comes jumbled up, i want to know if have an way to force the months months months to be ordenate, in the script or set analyses, I tried in the option "sort" in chart properties but none option was effective.

[jochem_zw · Accepted solution]

your month is based on a date or is it a text field?

if it is from a date field: month(Date)

if it is from a text field use dual function:

dual(‘January’,1)

dual(‘February’,2)

etc

when using it in chart it will sort correct!