Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
juleshartley
Specialist
Specialist

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
sunny_talwar

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
Specialist
Specialist
Author

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...

 

dilipranjith
Partner
Partner

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