Help required in ApplyMap

[qlikviewforum]

How can I create the applymap statement something like below in qlikview? I have issue with highlighted one below. I have column called Column1 and Column2 and EUR is hardcoded value. Please help on this.

applymap('AccountMap',Round(Column1/365,1)~Round(Column2/365,1)~'IND',1)

[Qrishna]

Hi,

In the above script make  Round(Column1/365,1)~Round(Column2/365,1)~'IND' as XYZ either in the mapping load statement or the table where you apply the map.

make sure the field names are same.

Eg:

AccountMap:

Mapping Load

Round(Column1/365,1)~Round(Column2/365,1)~'IND' as XYZ,

MAPPING KEY

FROM TABLE_ABC;

FACT:

LOAD A,B,

applymap('AccountMap',MAPPING KEY,1) AS  XYZ

FROM FACT.QVD;

Hope that helps.

Krishna