topic Re: Applymap in QlikView

Applymap

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

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

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

Thanks in Advance

Re: Applymap

Peter_Cammaert — Mon, 12 Jun 2017 09:34:20 GMT

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

Re: Applymap

lalitkgehlot89 — Mon, 12 Jun 2017 09:42:18 GMT

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

Re: Applymap

Anonymous — Mon, 12 Jun 2017 09:51:22 GMT

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

Return data type: dual

Arguments:

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

Re: Applymap

ngulliver — Wed, 09 Aug 2017 11:12:54 GMT

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

Re: Applymap

Anonymous — Wed, 09 Aug 2017 11:59:00 GMT

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