topic Re: Is there a vlookup function in QV in QlikView https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815967#M472317 <HTML><HEAD></HEAD><BODY><P>HI</P><P>it looks like you are from excel background to QV.</P><P>very much like myself.</P><P>Applymap works similar to V-lookup however, you can't select comumn numbers.</P><P>you load mapping table that only contains key value and lookup value.</P><P>applymap('Talbe name',keyvalue)</P><P>Tanks.</P></BODY></HTML> Tue, 20 Jan 2015 04:42:14 GMT john9inno 2015-01-20T04:42:14Z Is there a vlookup function in QV https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815966#M472316 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi all, I have two tables namely :Connectivity and Vessel_Details</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In the Vessel Details , I have the following fields : Vessel_Name, Voyage_No and Vessel_Direction. This contains a list of ALL vessels</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">For the Connectivity I have, Load_Vessel_Name ,Load Voyage_No, Disc_Vessel_Name, Disc_Voy. This shows the connection between vessels that discharge and vessels that load</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Note that the Load_Vessel_Name and Load_Voyage are connected to Vessel Details Vessel_Name and Voyage_No. Hence I am able to get the Load_Vessel_Direction by using Vessel Direction.This is done through connectivity_Key</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">However, I am stuck as I would need to create Disc_Direction by using 'mapping' on the Vessel_Name and Voyage_No. Is there anywhere i can do this in script level</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have attached the file. I need a new field call Disc_Direction</P></BODY></HTML> Tue, 20 Jan 2015 03:14:24 GMT https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815966#M472316 n1ef5ng1 2015-01-20T03:14:24Z Re: Is there a vlookup function in QV https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815967#M472317 <HTML><HEAD></HEAD><BODY><P>HI</P><P>it looks like you are from excel background to QV.</P><P>very much like myself.</P><P>Applymap works similar to V-lookup however, you can't select comumn numbers.</P><P>you load mapping table that only contains key value and lookup value.</P><P>applymap('Talbe name',keyvalue)</P><P>Tanks.</P></BODY></HTML> Tue, 20 Jan 2015 04:42:14 GMT https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815967#M472317 john9inno 2015-01-20T04:42:14Z Re: Is there a vlookup function in QV https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815968#M472318 <HTML><HEAD></HEAD><BODY><P>Lookup and Apply map&nbsp; two commands are there in Qlikview search for that.</P><P></P><P>Vikas</P></BODY></HTML> Tue, 20 Jan 2015 06:42:57 GMT https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815968#M472318 vikasmahajan 2015-01-20T06:42:57Z Re: Is there a vlookup function in QV https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815969#M472319 <HTML><HEAD></HEAD><BODY><P>Applymap is the equivalent of Vlookup.</P><P>There is an explanation of how this one use <STRONG>mapping </STRONG><STRONG>tables</STRONG> and applymap here<A href="https://community.qlik.com/qlik-blogpost/2756">Don't join - use Applymap instead</A></P></BODY></HTML> Tue, 20 Jan 2015 06:51:48 GMT https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815969#M472319 Colin-Albert 2015-01-20T06:51:48Z Re: Is there a vlookup function in QV https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815970#M472320 <HTML><HEAD></HEAD><BODY><P>Hi Benn,</P><P></P><P>Check out this link <A href="http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/" title="http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/">http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/</A></P><P></P><P>Hope this will help you </P></BODY></HTML> Tue, 20 Jan 2015 06:56:18 GMT https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815970#M472320 Anonymous 2015-01-20T06:56:18Z Re: Is there a vlookup function in QV https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815971#M472321 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check this thread for Lookup example</P><P><A href="https://community.qlik.com/docs/DOC-3903">Lookup function</A></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 20 Jan 2015 07:07:07 GMT https://community.qlik.com/t5/QlikView/Is-there-a-vlookup-function-in-QV/m-p/815971#M472321 jagan 2015-01-20T07:07:07Z