Expression to sort chart by two expressions

[#1]

Hello,

I have a dimension comprised of two fields - Month and Year (=%Month&' - '&%Year).

I want to sort my chart so that the order is chronological (Nov-13, Dec-13, Jan-14, Feb-14, etc.). Presumably I need to sort by year first, then by month. Does anyone have an formula that will work for this?

Thank you

Mel

[alexandros17 · Accepted solution]

Year*100 + Month

....

in this way you have a natural sort:

201401

201408

201501

...

let me know

[#3]

That's great, thank you!

[Anonymous]

When you create your dimension why not make it into QlikView MonthName format something like this

     =MonthName(MakeDate('2014','11'))

Then it will sort naturally as is and generally make your like easier.