topic Re: error in mapping -ApplyMap error: map_id must be a constant in Move to Qlik Cloud Analytics

error in mapping -ApplyMap error: map_id must be a constant

sourabhsharma — Tue, 27 Jan 2026 10:45:26 GMT

mapping:
mapping
LOAD Distinct
Managercode ,
Managername

FROM [lib://DataFiles/t_employee.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

emp:
LOAD
Managercode,
Employeeid,
Employeecode,
Name,
Emailid,
Gender,
applymap(Managername,Managercode)
FROM [lib://DataFiles/t_employee.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

exit script;

Re: error in mapping -ApplyMap error: map_id must be a constant

rwunderlich — Fri, 15 Dec 2023 22:35:32 GMT

It should be like:

applymap('mapping', Managercode) as Managername

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunctions/ApplyMap.htm

Although according to the Load of your mapping table you already have both Managercode and Managername in t_employee.csv. So I'm not sure why are you mapping anything.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: error in mapping -ApplyMap error: map_id must be a constant

sourabhsharma — Sat, 16 Dec 2023 17:07:20 GMT

yes It worked now,Actually i was trying to use map on dummy data.