topic Re: ApplyMap in QlikView

ApplyMap

Fri, 25 Apr 2014 11:24:03 GMT

Hello All,

Help me with ApplyMap, What is it ? how can we use it ? and why to use it? demo app would be great.

Re: ApplyMap

Fri, 25 Apr 2014 11:25:34 GMT

The ApplyMap function is used for mapping any expression to a previously loaded mapping table. The syntax is:

applymap('mapname', expr [ , defaultexpr ] )

where:

mapname is the name of a mapping table that has previously been created through the mapping load or the mapping select statement (see Mapping). Its name must be enclosed by single, straight Quotation Marks in Scripting.

expr is the expression, the result of which should be mapped.

defaultexpr is an optional expression which will be used as a default mapping value if the mapping table does not contain a matching value for expr. If no default value is given, the value of expr will be returned as is.

Examples:

// Assume the following mapping table:

map1:

mapping load * inline [

x, y

1, one

2, two

3, three ] ;

ApplyMap ('map1', 2 ) returns ' two'

ApplyMap ('map1', 4 ) returns 4

ApplyMap ('map1', 5, 'xxx') returns 'xxx'

ApplyMap ('map1', 1, 'xxx') returns 'one'

ApplyMap ('map1', 5, null( ) ) returns NULL

ApplyMap ('map1', 3, null( ) ) returns 'three'

Re: ApplyMap

Fri, 25 Apr 2014 11:52:33 GMT

thanks felim ,but i am not getting actual use of it ,possibly provide with more example

Re: ApplyMap

rustyfishbones — Fri, 25 Apr 2014 11:54:05 GMT

This may help

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

Re: ApplyMap

hic — Fri, 25 Apr 2014 12:00:00 GMT

Read this blog post: http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

HIC

Re: Re: ApplyMap

sudeepkm — Fri, 25 Apr 2014 12:08:37 GMT

Please take a look at the example attached and please refer to the comments added in the script.

Re: ApplyMap

Fri, 25 Apr 2014 12:11:37 GMT

Hi Rohit,

Mapping load works like a function/method in progrmming, first column acts as "input parameter" while second column acts as "return value". In below mapping load "x" acts as "input parameter" while "y" acts as "return value". if input value (x ) not found in table it returns same or third parameter of ApplyMap. ApplyMap is used to call mapping load and its syntax is applymap('mapname', expr [, defaultexpr ] ). After reload mapping load is not the part of data model.

map1:

mapping load * inline [

x, y

1, one

2, two

3, three ] ;

ApplyMap ('map1', 2 ) returns ' two'

ApplyMap ('map1', 4 ) returns 4

ApplyMap ('map1', 5, 0 ) returns 0

Re: Re: ApplyMap

Fri, 25 Apr 2014 12:24:09 GMT

Sudeep i coudnt find the attached file

Re: ApplyMap

Fri, 25 Apr 2014 12:24:43 GMT

Thank you HIC

Re: Re: Re: ApplyMap

sudeepkm — Fri, 25 Apr 2014 12:33:07 GMT

I'm attaching it again.