topic Lookup for similar value in App Development https://community.qlik.com/t5/App-Development/Lookup-for-similar-value/m-p/1999002#M82744 <P>Hello Experts,</P> <P>I have two Tables say A and B.</P> <TABLE style="width: 250px;" width="250"> <TBODY> <TR> <TD colspan="2" width="209">Table A</TD> </TR> <TR> <TD>PartnerName</TD> <TD>PartnerID</TD> </TR> <TR> <TD>Virat</TD> <TD>3517</TD> </TR> <TR> <TD>Rohit</TD> <TD>3084</TD> </TR> <TR> <TD>Dhawan</TD> <TD>3156</TD> </TR> <TR> <TD>Rahul</TD> <TD>5232</TD> </TR> <TR> <TD>Mahender</TD> <TD>2502</TD> </TR> <TR> <TD>Rishabh</TD> <TD>4782</TD> </TR> <TR> <TD>Ishan</TD> <TD>2940</TD> </TR> <TR> <TD>Pandya Brothers</TD> <TD>2832</TD> </TR> <TR> <TD>Bumrah</TD> <TD>3626</TD> </TR> <TR> <TD>Chahal</TD> <TD>4267</TD> </TR> <TR> <TD>Bhuvneshwar</TD> <TD>4567</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE class=" lia-align-left" style="width: 250px;" width="250"> <TBODY> <TR> <TD colspan="2" width="175">Table B</TD> </TR> <TR> <TD>PartnerName</TD> <TD>LeadType</TD> </TR> <TR> <TD>Virat</TD> <TD>B</TD> </TR> <TR> <TD>Rohit</TD> <TD>C</TD> </TR> <TR> <TD>Dhawan</TD> <TD>A</TD> </TR> <TR> <TD>Rahul</TD> <TD>B</TD> </TR> <TR> <TD>Mahender</TD> <TD>C</TD> </TR> <TR> <TD>Rishabh</TD> <TD>A</TD> </TR> <TR> <TD>Ishan</TD> <TD>B</TD> </TR> <TR> <TD>Pandya Brothers</TD> <TD>C</TD> </TR> <TR> <TD>Bumrah</TD> <TD>A</TD> </TR> <TR> <TD>Chahal</TD> <TD>B</TD> </TR> <TR> <TD>Bhuvneshwar</TD> <TD>C</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>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</P> <P>Action : Selected one Row from Table A</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Agrobhush00_0-1667301454644.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92592i85CC16B591CBED53/image-size/small?v=v2&amp;px=200" role="button" title="Agrobhush00_0-1667301454644.png" alt="Agrobhush00_0-1667301454644.png" /></span></P> <P>Result of Rahul in Table B</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Agrobhush00_2-1667301641401.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92593i354253E49D80FDC4/image-size/small?v=v2&amp;px=200" role="button" title="Agrobhush00_2-1667301641401.png" alt="Agrobhush00_2-1667301641401.png" /></span></P> <P>Is it possible using apply map or lookup function, Thanks for the solution.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>&nbsp;</P> Tue, 01 Nov 2022 11:43:07 GMT Agrobhush00 2022-11-01T11:43:07Z Lookup for similar value https://community.qlik.com/t5/App-Development/Lookup-for-similar-value/m-p/1999002#M82744 <P>Hello Experts,</P> <P>I have two Tables say A and B.</P> <TABLE style="width: 250px;" width="250"> <TBODY> <TR> <TD colspan="2" width="209">Table A</TD> </TR> <TR> <TD>PartnerName</TD> <TD>PartnerID</TD> </TR> <TR> <TD>Virat</TD> <TD>3517</TD> </TR> <TR> <TD>Rohit</TD> <TD>3084</TD> </TR> <TR> <TD>Dhawan</TD> <TD>3156</TD> </TR> <TR> <TD>Rahul</TD> <TD>5232</TD> </TR> <TR> <TD>Mahender</TD> <TD>2502</TD> </TR> <TR> <TD>Rishabh</TD> <TD>4782</TD> </TR> <TR> <TD>Ishan</TD> <TD>2940</TD> </TR> <TR> <TD>Pandya Brothers</TD> <TD>2832</TD> </TR> <TR> <TD>Bumrah</TD> <TD>3626</TD> </TR> <TR> <TD>Chahal</TD> <TD>4267</TD> </TR> <TR> <TD>Bhuvneshwar</TD> <TD>4567</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE class=" lia-align-left" style="width: 250px;" width="250"> <TBODY> <TR> <TD colspan="2" width="175">Table B</TD> </TR> <TR> <TD>PartnerName</TD> <TD>LeadType</TD> </TR> <TR> <TD>Virat</TD> <TD>B</TD> </TR> <TR> <TD>Rohit</TD> <TD>C</TD> </TR> <TR> <TD>Dhawan</TD> <TD>A</TD> </TR> <TR> <TD>Rahul</TD> <TD>B</TD> </TR> <TR> <TD>Mahender</TD> <TD>C</TD> </TR> <TR> <TD>Rishabh</TD> <TD>A</TD> </TR> <TR> <TD>Ishan</TD> <TD>B</TD> </TR> <TR> <TD>Pandya Brothers</TD> <TD>C</TD> </TR> <TR> <TD>Bumrah</TD> <TD>A</TD> </TR> <TR> <TD>Chahal</TD> <TD>B</TD> </TR> <TR> <TD>Bhuvneshwar</TD> <TD>C</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>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</P> <P>Action : Selected one Row from Table A</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Agrobhush00_0-1667301454644.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92592i85CC16B591CBED53/image-size/small?v=v2&amp;px=200" role="button" title="Agrobhush00_0-1667301454644.png" alt="Agrobhush00_0-1667301454644.png" /></span></P> <P>Result of Rahul in Table B</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Agrobhush00_2-1667301641401.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92593i354253E49D80FDC4/image-size/small?v=v2&amp;px=200" role="button" title="Agrobhush00_2-1667301641401.png" alt="Agrobhush00_2-1667301641401.png" /></span></P> <P>Is it possible using apply map or lookup function, Thanks for the solution.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>&nbsp;</P> Tue, 01 Nov 2022 11:43:07 GMT https://community.qlik.com/t5/App-Development/Lookup-for-similar-value/m-p/1999002#M82744 Agrobhush00 2022-11-01T11:43:07Z Re: Lookup for similar value https://community.qlik.com/t5/App-Development/Lookup-for-similar-value/m-p/1999377#M82765 <P>watch this video on how Qlik associated engine works</P> <P>&nbsp;</P> <P><A href="https://www.youtube.com/watch?v=DuULZtyjrqU" target="_blank">https://www.youtube.com/watch?v=DuULZtyjrqU</A></P> <P>&nbsp;</P> Wed, 02 Nov 2022 06:51:47 GMT https://community.qlik.com/t5/App-Development/Lookup-for-similar-value/m-p/1999377#M82765 vinieme12 2022-11-02T06:51:47Z Re: Lookup for similar value https://community.qlik.com/t5/App-Development/Lookup-for-similar-value/m-p/1999381#M82766 <P><SPAN class="pluma-sent-0">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.</SPAN></P> <P><SPAN class="pluma-sent-0">When the script is executed in your case, the two logical tables created are associated with one another based on the PartnerName field.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrunPierre_0-1667371662034.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92683i4C2173C51A88B310/image-size/medium?v=v2&amp;px=400" role="button" title="BrunPierre_0-1667371662034.png" alt="BrunPierre_0-1667371662034.png" /></span></P> <P>As a result, when a selection is made they will perform a linkage as shown.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrunPierre_1-1667371916961.png" style="width: 504px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92684i0725DD6F75413622/image-dimensions/504x63?v=v2" width="504" height="63" role="button" title="BrunPierre_1-1667371916961.png" alt="BrunPierre_1-1667371916961.png" /></span></P> Wed, 02 Nov 2022 06:54:43 GMT https://community.qlik.com/t5/App-Development/Lookup-for-similar-value/m-p/1999381#M82766 BrunPierre 2022-11-02T06:54:43Z