Sort year and month

[cristianj23a]

I am trying to sort my simple table in year and month.

But from 2017 begins with the month of March.

Tatre to classify concatenando the year and the month, converting in format number to order from minor to major, but it remains the same.

Please help me on this topic.

Thank you.

I attach an example of qvw and excel.

[antoniotiman]

Hi Cristian,

what about to change Dimension from Ano_Mes to MonthName([Fecha de Ejecución]) ?

Regards,

Antonio

[hic · Accepted solution]

You can use any one of the following two expressions to define a new Ano_Mes

MonthName([Fecha de Ejecución]) as Ano_Mes

Date(MonthStart([Fecha de Ejecución]),'YYYY MMM') as Ano_Mes

Both expressions will produce a Dual that can be sorted numerically, to get the dates in the right order.

HIC

[cristianj23a]

Hi Antonio.

The user wants to display the year and month concatenated.

I found the solution, thanks antonio.

Greetings.