How can I sort the MonthYear Chart ?

[suzel404]

Hi all,

I create a chart with 12 Rolling Average Months but I cannot sort MonthYear by ASC.

Thank for your help.

[MarcoWedel · Accepted solution]

Get the Dates Right

Maybe this helps

Regards

Marco

[Oleg_Troyansky]

What Marco is trying to say, is - your Month-Year dimension is a string, not a Date field, and therefore it can't be sorted properly.

The most commonly used formula for calculating Month-Year is this:

Date(MonthStart(Date), 'MMM-YYYY') as MonthYear.

This is typically done within the MasterCalendar load.

cheers,

Oleg Troyansky

Check out my book QlikView Your Business - now available to pre-order on Amazon!

[suzel404]

Thanks guys!

[MarcoWedel]

You're welcome

regards

Marco