Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikcheepirishe
Creator
Creator

ApplyMap()

While using Applymap Function not getting required output.

6 Replies
jonathandienst

Looks OK. Whats are you getting as output and what do you expect?

The amount and accuarcy of the advice you will receive here is directly proportional to the amount of information you supply.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
qlikview979
Specialist
Specialist

Hi do like this

T1:

mapping LOAD *Inline [

Name,Age

CS,23

Mahesh,24

Dhaval,23

Rutale,24

Rajini,24

Swati,24

];

T2:

LOAD * Inline [

Name,Surname,

CS,Shukla

CS,Shukla

Mahesh,Cheepiri

Dhaval,Vyas

Swati,moku

Shreya,shukla

];

NoConcatenate

T2:

LOAD

RecNo() as Rec,

Name,Surname,

ApplyMap('T1',Name,'Missing') as Age

Resident T2;

DROP Table T2;

Untitled.png

qlikviewnovice
Specialist II
Specialist II

It works perfectly. What is your expected output?

Please find attached application

qlikview979
Specialist
Specialist

I think,

As per second table  CS name having two times ,may be he is expecting two times same name in front end also,for that we need to add recno() function.

qlikviewnovice
Specialist II
Specialist II

Might be you are right

qlikcheepirishe
Creator
Creator

Thnkz @mahesh Kumar for the help