Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatg6759
Creator III
Creator III

Look up and join

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

1 Reply
Anonymous
Not applicable

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