Dates in chart are not sorting correctly

[Sam_Thomas]

Hi, very new to qliksense, still trying to get my head around some things. 

Someone has already kindly help me build a combo chart for my dashboard utilising the load editor, however, the dates on the x-axis are not formatting/sorting correctly. I would obviously like the dates to run in ascending order. I think maybe the dates aren't formatted as dates perhaps?

Please see below example picture. 

Please let me know if you require any more information. Any help would be greatly appreciated. 

[deshikas]

Use Dual function around the date

[Sam_Thomas]

Thanks for the answer. 

My dimension expression is =If(Not(IsNull(CalendarDate)),Month(CalendarDate)&' '&Year(CalendarDate))

How would I go about using a Dual Function?

Thanks.

[deshikas]

in script Dual(calendar date)

[Vegar]

You could use monthname if you are OK with the default formatting of that function.

=MonthName(CalendarDate)

[Vegar · Accepted solution]

... if monthName() doesn't meet your demands then try this.

=If(Not(IsNull(CalendarDate)), Dual(Month(CalendarDate)&' '&Year(CalendarDate), monthname(CalendarDate)))

[Sam_Thomas]

Brilliant. Worked wonderfully, thanks. 

[Sam_Thomas]

I am not sure if I should start a new thread or not, but I may as well ask. Do you know how I might go about limiting the dimension to only provide the last 12 months worth of data? 

For example, I have data going back to 2017, but I would only want to see the last 12 months? Is this possible?

Thanks again, big help.