Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jonesbrown
Creator
Creator

What  is  Applymap where we Use Give an example ?

Hi All

I am new to Qlikview

What  is  Applymap where we Use Give an example ?

plz help.

Labels (1)
3 Replies
ramasaisaksoft

Hi Jones,

 

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

Ex:-

T1:

Mapping Load

EID,

Ename

from......;

T2:

Load

A,

B,

C,

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

D

From ......;

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

Conditions while we are using ApplyMap()

  1. Before using ApplyMap() there should be Mapping Load table Exist
  2. 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.

 

Surya
Creator II
Creator II

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

 

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.