topic Re: What is Applymap where we Use Give an example ? in QlikView

What is Applymap where we Use Give an example ?

jonesbrown — Sat, 16 Nov 2024 19:43:13 GMT

Hi All

I am new to Qlikview

What is Applymap where we Use Give an example ?

plz help.

Re: What is Applymap where we Use Give an example ?

ramasaisaksoft — Fri, 08 Nov 2019 07:12:04 GMT

Hi Jones,

when ever we need to use VLOOKUP() in QlikView we will use APPlyMap()

Ex:-

T1:

Mapping Load

EID,

Ename

from......;

T2:

Load

ApplyMap('T1',EID,Null()) as "Employeename",

From ......;

So after execution of script at the end Automatically T1 table will drop.

Conditions while we are using ApplyMap()

Before using ApplyMap() there should be Mapping Load table Exist
Mapping Load table must should have only 2 dimensions in that table. (Ex: EID, EName)

Please go with some other links mentioned below for more understand

https://community.qlik.com/t5/QlikView-App-Development/quick-applymap-example/td-p/515616

if you still not clear reach out me on +91 8376 964 364.

Re: What is Applymap where we Use Give an example ?

Surya — Fri, 08 Nov 2019 07:36:29 GMT

Hlo.,

when ever we need to use applymap in Qlikview

w e having certain rules .,mainly applymap use to map field to another table like VLOOKUP()

we are using mapping as prefix for loading table it is always return in before applymap

like ..

map:

mapping load a,b

from path;

load *,

applymap('map',a) //here map is above table name and a is common field from 2 table

....

in mapping table always having 2 fields only.

1. Key field

2.Mapping field

......

and the main diference of left join and applymap is

.........................................

Sno,Name

1,surya

2,Jones

3,Vinayak

1,Prakash

........................

when you do applymap

1,surya

2,Jones

3,Vinayak

1,surya

when you do left join

1,surya

2,Jones

3,Vinayak

1,Prakash

Re: What is Applymap where we Use Give an example ?

Brett_Bleess — Wed, 13 Nov 2019 13:21:38 GMT

Jones, have a look at the following Design Blog link, hopefully that will get you what you need on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Regards,
Brett