Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Expression to sort chart by two expressions

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

Tags (1)
1 Solution

Accepted Solutions

Re: Expression to sort chart by two expressions

Year*100 + Month

....

in this way you have a natural sort:

201401

201408

201501

...

let me know

3 Replies

Re: Expression to sort chart by two expressions

Year*100 + Month

....

in this way you have a natural sort:

201401

201408

201501

...

let me know

Not applicable

Re: Expression to sort chart by two expressions

That's great, thank you!

Re: Expression to sort chart by two expressions

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.

Community Browser