HI all

Wed, 19 Nov 2014 08:15:47 GMT

What is apply map and what are the use? where we use this apply map?

Re: HI all

sujeetsingh — Wed, 19 Nov 2014 08:22:11 GMT

Follow these

Map..Using (mapping) fucntion Info please..

Re: HI all

jagan — Wed, 19 Nov 2014 08:26:11 GMT

Hi Madhu,

Check this from Qlikview help (F1) file.

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'

Regards,

jagan.

Re: HI all

Wed, 19 Nov 2014 11:15:08 GMT

Thanq Jagan

one interviewer asked the question before creating the dashboard how to design and how show ?

topic Re: HI all in QlikView

HI all

Re: HI all

Re: HI all

Re: HI all

Re: HI all