Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted

Re: Applymap

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

Highlighted
Creator II
Creator II

Re: Applymap

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

Highlighted
Specialist II
Specialist II

Re: Applymap

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

Highlighted
Partner
Partner

Re: Applymap

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

Highlighted
Creator II
Creator II

Re: Applymap

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