Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between left join vs apply map

for my knowledge i want to know difference between left join and apply map

i know its good for optimization

but how ??

10 Replies
Contributor III
Contributor III


You don't have to create three mapping tables to get the fields through applymap.You can do it thought one mapping table like the below example.

Map Countries:

Mapping Load 

Country Code,

Country name&'|'&Country Currency as Country data 

Resident Country;


Load *,

Subfield(Applymap('Map Countries',Country Code,null()),'|',1) As Country Name,

Subfield(Applymap('Map Countries',Country Code,null()),'|',2) As Country Currency

Resident Customers;