Help required in ApplyMap

qlikviewforum — Wed, 27 May 2015 15:22:31 GMT

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)

Re: Help required in ApplyMap

Qrishna — Wed, 27 May 2015 15:30:02 GMT

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

topic Re: Help required in ApplyMap in QlikView

Help required in ApplyMap

Re: Help required in ApplyMap