Lookup for similar value

[Agrobhush00]

Hello Experts,

I have two Tables say A and B.

Table A
PartnerName	PartnerID
Virat	3517
Rohit	3084
Dhawan	3156
Rahul	5232
Mahender	2502
Rishabh	4782
Ishan	2940
Pandya Brothers	2832
Bumrah	3626
Chahal	4267
Bhuvneshwar	4567

Table B
PartnerName	LeadType
Virat	B
Rohit	C
Dhawan	A
Rahul	B
Mahender	C
Rishabh	A
Ishan	B
Pandya Brothers	C
Bumrah	A
Chahal	B
Bhuvneshwar	C

When I select row from Table A let's say Rahul. Then the table B must show only the matching result Rahul in Table B

Action : Selected one Row from Table A

Result of Rahul in Table B

Is it possible using apply map or lookup function, Thanks for the solution.

[vinieme12]

watch this video on how Qlik associated engine works

https://www.youtube.com/watch?v=DuULZtyjrqU

[BrunPierre]

If there's a field with the same name in two tables, Qlik makes an association and performs the joins when a selection is made.

When the script is executed in your case, the two logical tables created are associated with one another based on the PartnerName field.

As a result, when a selection is made they will perform a linkage as shown.