topic Re: Similar to the function formula Vlookup in QlikView https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847060#M470336 <HTML><HEAD></HEAD><BODY><P>It can't be done by looking up a cell in another (straight/pivot) table object, but can be done by set analysis. What we need to know/understand are the logical tables in the background (data fields and tables involved) and the dimensions / expressions of your table objects.</P></BODY></HTML> Mon, 25 May 2015 23:19:58 GMT danieloberbilli 2015-05-25T23:19:58Z Similar to the function formula Vlookup https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847059#M470335 <HTML><HEAD></HEAD><BODY><P>The tenth column of the second table is the last No. SO, what I want is that in the last column the price of the last sales order that is marked in the first table also appears.</P><P>Says 17.91, should read 16.66</P><P></P><P><IMG __jive_id="87474" alt="Sin título.jpg" class="jive-image image-1" src="/legacyfs/online/87474_Sin título.jpg" style="height: 179px; width: 620px;" /></P></BODY></HTML> Mon, 25 May 2015 23:04:41 GMT https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847059#M470335 stvn_003 2015-05-25T23:04:41Z Re: Similar to the function formula Vlookup https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847060#M470336 <HTML><HEAD></HEAD><BODY><P>It can't be done by looking up a cell in another (straight/pivot) table object, but can be done by set analysis. What we need to know/understand are the logical tables in the background (data fields and tables involved) and the dimensions / expressions of your table objects.</P></BODY></HTML> Mon, 25 May 2015 23:19:58 GMT https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847060#M470336 danieloberbilli 2015-05-25T23:19:58Z Re: Similar to the function formula Vlookup https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847061#M470337 <HTML><HEAD></HEAD><BODY><P>I am attaching the file</P></BODY></HTML> Mon, 25 May 2015 23:24:57 GMT https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847061#M470337 stvn_003 2015-05-25T23:24:57Z Re: Similar to the function formula Vlookup https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847062#M470338 <HTML><HEAD></HEAD><BODY><P>Hi Steven,</P><P>use this expression. <BR />find the attachment =Alt(min({$}ocd_iprnetsap),0)</P></BODY></HTML> Tue, 26 May 2015 03:28:28 GMT https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847062#M470338 Siva_Sankar 2015-05-26T03:28:28Z Re: Similar to the function formula Vlookup https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847063#M470339 <HTML><HEAD></HEAD><BODY><P>Thanks Siva, but that only works for this specific case, but there may be cases where it is higher, lower or middle</P></BODY></HTML> Tue, 26 May 2015 14:46:44 GMT https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847063#M470339 stvn_003 2015-05-26T14:46:44Z Re: Similar to the function formula Vlookup https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847064#M470340 <HTML><HEAD></HEAD><BODY><P>any idea for this, please</P></BODY></HTML> Fri, 29 May 2015 14:35:54 GMT https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847064#M470340 stvn_003 2015-05-29T14:35:54Z Re: Similar to the function formula Vlookup https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847065#M470341 <HTML><HEAD></HEAD><BODY><P>you can use this </P><P></P><P>only({&lt; occ_nocedi = {"$(=MaxString({$&lt;ocd_precio_ok = {N} &gt;} (occ_nocedi)))"} &gt;} ocd_iprnetsap)</P></BODY></HTML> Fri, 29 May 2015 15:44:35 GMT https://community.qlik.com/t5/QlikView/Similar-to-the-function-formula-Vlookup/m-p/847065#M470341 ramoncova06 2015-05-29T15:44:35Z