Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

commonqlik
Contributor III

app map?

when i go for applymap

t1:

mapping load

f1,

f2

from

sales.xlsx

t2:

load

f3

f4

f5

applymap('t1',f3,'un') as newmap

from bud.xlsx


her emy question is if i given f3 in applymap statment which is not matching in  t1 table

generally first f3 will go for comparision with  f1 or f2   or both f1 and f2

it means it check the matching data with only f1 or  f2 also?  or it ignore f2 field?

1 Solution

Accepted Solutions
balkumarchandel
Valued Contributor II

Re: app map?

It will only check with f1 and if f1 and f3 is mapping it will give f2 value as newmap else un

Thank BKC

4 Replies
balkumarchandel
Valued Contributor II

Re: app map?

It will only check with f1 and if f1 and f3 is mapping it will give f2 value as newmap else un

Thank BKC

Highlighted
Partner
Partner

Re: app map?

When you use a map,

if your content in f3 matches your content in f1 then it returns the value in f2. But if doesn´t match f3 in f1, then it returns 'un' (in your case)

Greetings!

commonqlik
Contributor III

Re: app map?

it means it is always go for comparision with first field right ?

mapping table syntax like

t1:

mapping load

id,

value

from sales.xlsx

balkumarchandel
Valued Contributor II

Re: app map?

Yes