Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Applymap

Hi All ,

Can someone please explain me what is this below applymap does ?

where ApplyMap('Disposition_Email',Lead_UID,'No')='No';

Thanks in Advance

5 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Loads all rows with a Lead_UID value that doesn't appear in mapping table 'Disposition_Email', or that does appear in the mapping table but with a translation value of 'No'.

See here: ApplyMap ‒ QlikView

lalitkgehlot89
Creator II
Creator II

Loads all rows with Lead_UID value that appears in second column of mapping table with the condition "NO'.

Anonymous
Not applicable

Hi

ApplyMap('map_name', expression [ , default_mapping ] )

Return data type: dual

Arguments:

ArgumentDescription
map_name   The name of a mapping table that has previously been created through the mapping load or the mapping select statement. Its name must be enclosed by single, straight quotation marks.
expression   The expression, the result of which should be mapped.
default_mapping  

If stated, this value will be used as a default value if the mapping table does not contain a matching value for expression. If not stated, the value of expression will be returned as is.

Hope it helps!!

ngulliver
Partner - Specialist III
Partner - Specialist III

In addition to Peter's link, have a look at Steve's blog which illustrates how you can get the most out of Applymap

https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Cheers,

Neil

Anonymous
Not applicable

it will return the results with no mapping in the mapping table, as default mapping defined is 'no' and in where condition it is checking load only records with name as 'no'.