topic MAP in QLIKVIEW in QlikView

MAP in QLIKVIEW

Mon, 20 Sep 2010 16:23:52 GMT

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

MAP in QLIKVIEW

Miguel_Angel_Baeyens — Mon, 20 Sep 2010 16:31:40 GMT

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

Re. :Re: MAP in QLIKVIEW

Mon, 20 Sep 2010 17:10:24 GMT

Thank you Miguel. It's OK