topic Re: Look up and join in QlikView https://community.qlik.com/t5/QlikView/Look-up-and-join/m-p/598500#M221594 <HTML><HEAD></HEAD><BODY><P>Pls import both table in qlikview and try.</P><P>Qlikview will automatically match your data by the common field "Issuer name" and then you can try this graph.</P><P>Let us know if you face any issues</P></BODY></HTML> Mon, 21 Apr 2014 14:09:53 GMT Anonymous 2014-04-21T14:09:53Z Look up and join https://community.qlik.com/t5/QlikView/Look-up-and-join/m-p/598499#M221593 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>I have 2 tables named Sustain and Equity .</P><P>I have a field called Issuer Name in both the tables where i did&nbsp; vlookup to get the issuers that exist in sustain.</P><P><SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">I noted these with an “X”. then&nbsp; I did a vlookup to bring in the Sustain authors name.</SPAN></P><P>I created a new tab with only the issuers marked&nbsp; X for sustain coverage. Out of this universe I determined the #s covered per region and per Equity analyst (this&nbsp; showed&nbsp; the overlap between equity and Sustain coverage).</P><P>I did the above by excel.</P><P>I need the graph to look like the one in the attachment .Please check the attachment.</P><P></P><P>How could i acheive this in Qlikveiw .</P><P></P><P>Thanks,</P><P>Venkata</P></BODY></HTML> Mon, 21 Apr 2014 13:51:58 GMT https://community.qlik.com/t5/QlikView/Look-up-and-join/m-p/598499#M221593 venkatg6759 2014-04-21T13:51:58Z Re: Look up and join https://community.qlik.com/t5/QlikView/Look-up-and-join/m-p/598500#M221594 <HTML><HEAD></HEAD><BODY><P>Pls import both table in qlikview and try.</P><P>Qlikview will automatically match your data by the common field "Issuer name" and then you can try this graph.</P><P>Let us know if you face any issues</P></BODY></HTML> Mon, 21 Apr 2014 14:09:53 GMT https://community.qlik.com/t5/QlikView/Look-up-and-join/m-p/598500#M221594 Anonymous 2014-04-21T14:09:53Z