Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Year*100 + Month
....
in this way you have a natural sort:
201401
201408
201501
...
let me know
Year*100 + Month
....
in this way you have a natural sort:
201401
201408
201501
...
let me know
That's great, thank you!
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.