Sorting for MonthYear

[sspawar88]

Hi,

I'm Having Dimension MonthYear in Which Values are like Feb2015, Mar2015, Feb2016, April 2016.

How can i sort them in Bar chart ?

[Anonymous · Accepted solution]

Hi Satish,

You can order it by Expression, if you have a date associated: =Max({1} Date).

Regards!

[tamilarasu]

You can use below sort expression

=Date(Date#(MonthYear,'MMMYYYY'))

[MayilVahanan]

Hi

If you don't have any date column, try like below

LOAD MonthName(Date#(Month, 'MMMYYYY')) as Month Inline

[

Month

Feb2015,

Mar2015,

Feb2016,

Apr2016

];

And then sort by Numeric Value in Sort Tab

[jonathandienst]

If MonthYear is a valid QV date numeric, then sort numerically.

If MonthYear is a string, change your load so that it is converted into a date type.

     LOAD

          ...

          Date#(MonthYear, 'MMMyyyy') as MonthYear,

          ...

and then sort numerically.

[susovan]

Hi Satish,

Try this

[Chanty4u]

hi

Create your Month_Year field as a date in the script: Date(MonthStart(MyDate),'YYYYMMM') as Month_Year. Then sort it by Numeric Value in the chart.

chk similar thread

RE:Bar Sort order

[maksim_senin]

Hi,

Also it's usefull to use Dual() function. Please refer to QV reference.

Best regards,

Maxim

[ziadm]

Load

Dual(Date(MonthStart(DateField),'YYYYMMM') ,DateField) as MonthYear