Look up and join

[venkatg6759]

Hello Everyone,

I have 2 tables named Sustain and Equity .

I have a field called Issuer Name in both the tables where i did  vlookup to get the issuers that exist in sustain.

I noted these with an “X”. then  I did a vlookup to bring in the Sustain authors name.

I created a new tab with only the issuers marked  X for sustain coverage. Out of this universe I determined the #s covered per region and per Equity analyst (this  showed  the overlap between equity and Sustain coverage).

I did the above by excel.

I need the graph to look like the one in the attachment .Please check the attachment.

How could i acheive this in Qlikveiw .

Thanks,

Venkata

[Anonymous]

Pls import both table in qlikview and try.

Qlikview will automatically match your data by the common field "Issuer name" and then you can try this graph.

Let us know if you face any issues