Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi Cristian,
what about to change Dimension from Ano_Mes to MonthName([Fecha de Ejecución]) ?
Regards,
Antonio
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
Hi Antonio.
The user wants to display the year and month concatenated.
I found the solution, thanks antonio.
Greetings.