Order MONTH

[Demha_2022]

Hello all,

I am developping an application with qlikview , i'am beginner , i have a problem.

My problème is , i hope to order my MONTH , for exemple : 

I want to have by order en qlikview : Janvier, Février, Mars , Avril , Mai , Juin , Juillet , Aout , Septembre , Octobre, Novembre Décembre.

Please can you hel me ?

[MarcoWedel]

can you post the relevant part of your script that generates the MOIS field?

[Demha_2022]

Hello, 

Thank you your answer , this is the part of my script that generates the MOIS field.

The MOIS field is MONTH

mapMonth:
mapping load

AutoNumber('S'&Week(DT_CLOTURE,5,0,4)&Year(DT_CLOTURE)) AS IDMonth
,Max(Month(DT_CLOTURE))
//,DT_CLOTURE
FROM [$(p_Path_Data_QvdDWH)Action.qvd] (qvd)

Group by AutoNumber('S'&Week(DT_CLOTURE,5,0,4)&Year(DT_CLOTURE));

Action:

LOAD

DT_CLOTURE ,

  Week(DT_CLOTURE, 5,0,4)                                   AS SEMAINE_NORMALE,
'S'& Week(DT_CLOTURE,5,0,4)                              AS SEMAINE,

pick(ApplyMap('mapMonth',
Autonumber('S'& Week(DT_CLOTURE,5,0,4) &Year (DT_CLOTURE))),
'Janvier','Février','Mars','Avril','Mai','Juin','Juillet','Août','Septembre','Octobre','Novembre','Décembre')    AS "MONTH",

FROM [$(p_Path_Data_QvdDWH)Action.qvd] (qvd);

ApplyMap('mapMonth',
Autonumber('S'& Week(DT_CLOTURE,5,0,4) &Year(DT_CLOTURE))) AS "NUM_MONTH"