Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I create a chart with 12 Rolling Average Months but I cannot sort MonthYear by ASC.
Thank for your help.
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!
Thanks guys!
You're welcome
regards
Marco