Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
juleshartley
Valued Contributor

Ampersand with Applymap

Hi all,

I came across an odd issue today...

When using Applymap() with an '&' in the field being mapped, it gives an incorrect answer. 

Has anyone experienced this?

Thanks,
J

 

Labels (1)
4 Replies

Re: Ampersand with Applymap

Would you be able to share an example of where the & is? Is it in the field from which you map from or is the & used in map to?

juleshartley
Valued Contributor

Re: Ampersand with Applymap

so the mapping load uses a text field to map to an id eg:

MapComID:

CompanyName, ID

John & James, 123

 

then applymap then using companyname...

 

Partner
Partner

Re: Ampersand with Applymap

From what i know theres no issues with &. ran a simple test below

companymap:
mapping load * inline [
CompanyName, ID
John & James, 123
Jack,321
Jack & Jill, 456
]
;
Test:
load *,
ApplyMap('companymap',CompanyName,'')as ID;
Load * Inline [
CompanyName, Sales
John & James, 10000
Jack,1300
Jack & Jill, 1500

]
;

Output is correct

Capture.PNG

Most likely check your source file/tables. Seem to remember few threads where excel  messed something up resulting in issues which seemed like & issue you mentioned

Partner
Partner

Re: Ampersand with Applymap