MAP in QLIKVIEW

[#1]

Hi Community,

Please can someone explain me how to use MAP in Qlikview script.

I want to substitute replace several values as:

"P1" by "Début d'exercice" ,

"P2" by "Embauches" ,

"P3" by "Départs" ,

"P4" by "Fin d'exercice" .

I have a pivot table that the values of a column are P1, P2, P3, P4 and i want to replace theses values respectively by "Debut d'exercice",

"Embauches" , "Départs" , "Fin d'exercice" .

Thanks you

[Miguel_Angel_Baeyens]

Hello Yimen,

Do that in the load script so

DimensionMap:MAPPING LOAD * INLINE [Original, NewP1, Début d'exerciceP2, EmbauchesP3, DépartsP4, Fin d'exercice];
... rest of your script here ...
Table:LOAD Field1, Dimension, Applymap('DimensionMap', Dimension) AS DimensionToPivotFROM ...

Hope that helps

[#3]

Thank you Miguel. It's OK