topic Order MONTH in QlikView

Order MONTH

Demha_2022 — Thu, 07 Jul 2022 19:02:15 GMT

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 ?

Re: Order MONTH

MarcoWedel — Thu, 07 Jul 2022 19:44:07 GMT

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

Re: Order MONTH

Demha_2022 — Fri, 08 Jul 2022 13:42:23 GMT

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"