Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
suzel404
Creator
Creator

How can I sort the MonthYear Chart ?

Hi all,

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

Thank for your help.

1 Solution

Accepted Solutions
MarcoWedel

4 Replies
MarcoWedel

Get the Dates Right

Maybe this helps

Regards

Marco

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator
Creator
Author

Thanks guys!

MarcoWedel

You're welcome

regards

Marco