topic Re: Mapping or vLookup alternative in QlikView https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392600#M615459 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P>Attached is the qvw file.</P></BODY></HTML> Fri, 11 Aug 2017 20:25:17 GMT vishsaggi 2017-08-11T20:25:17Z Mapping or vLookup alternative https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392599#M615458 <HTML><HEAD></HEAD><BODY><P>I'm new to using the vLookup feature in excel. I am required to match a column from one document to another to add a new column with the correct values. I'm not really sure what I'm asking but I will attach the excel doc and my app to see if it is possible. I have been researching the Mapping feature, but just not sure how to implement it with these files.</P><P></P><P>The ZB_KPI file has the pivot table i am trying to create in Qlik. </P><P>But essentially I want to just be able to upload the RAW DATA instead of doing the vlookups in excel. </P><P></P><P>This is the vLookup equation:</P><P>=VLOOKUP(B2,'Header Data'!$A$2:$H$498,8,FALSE)</P></BODY></HTML> Fri, 11 Aug 2017 19:47:57 GMT https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392599#M615458 joshrussin 2017-08-11T19:47:57Z Re: Mapping or vLookup alternative https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392600#M615459 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P>Attached is the qvw file.</P></BODY></HTML> Fri, 11 Aug 2017 20:25:17 GMT https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392600#M615459 vishsaggi 2017-08-11T20:25:17Z Re: Mapping or vLookup alternative https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392601#M615460 <HTML><HEAD></HEAD><BODY><P>Had to do a few minor adjustments but it works perfectly, thank you so much!</P></BODY></HTML> Fri, 11 Aug 2017 21:49:23 GMT https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392601#M615460 joshrussin 2017-08-11T21:49:23Z Re: Mapping or vLookup alternative https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392602#M615461 <HTML><HEAD></HEAD><BODY><P>I'm having some issues with a new part of this app. Could you take a look please?</P><P></P><P><A href="https://community.qlik.com/thread/271202">Script merging</A></P></BODY></HTML> Tue, 15 Aug 2017 17:12:45 GMT https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392602#M615461 joshrussin 2017-08-15T17:12:45Z Re: Mapping or vLookup alternative https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392603#M615462 <HTML><HEAD></HEAD><BODY><P>Ok i will look into it in a while. </P></BODY></HTML> Tue, 15 Aug 2017 17:25:01 GMT https://community.qlik.com/t5/QlikView/Mapping-or-vLookup-alternative/m-p/1392603#M615462 vishsaggi 2017-08-15T17:25:01Z