Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Join issue

Hi,

As a newbie on QlikView I've got in to a challange on joins (I think...). In this case I have two qvd-tables, Company and CompanyInformation. Unfortunately CompanyInformation.qvd conatins more records than I have active companies in the Company.qvd. In my Chart (Pivot Table/Straight Table) I want to show information on records that is present in both tables only.

This is a short example of my case:

Company.qvd contains

NamePhoneCreatedDateClosedDatefk_CompanyInformationId
A555-103-00019.01.20071
B555-103-00125.08.20032
C555-103-00230.01.20014
D555-103-00316.05.20075


CompanyInformation.qvd contains

CompanyInformationIdGLNContactName
17080000000100Torgersen
27080000000120Rahmanian
3

7080000000125

Evje
47080000000178Jansson
57080000000183Olsen
67080000000210Myrhaug
77080000000325Brunner


And this is what I want to show in my Chart (Pivot Table/Straight Table):

CompanyInformationIdGLNCompanyName
17080000000100A
27080000000120B
47080000000178C
57080000000183D


Any suggestions?

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Company:

     Load

                Name as CompanyName,

               fk_CompanyInformationId as CompanyInformationId,

     From

          Company.qvd;

Left Join(Company)

     Load

               CompanyInformationId,

               GLN

     From

          CompanyInformation.qvd;

QV automatically joins the table based on the common field name

Hope it helps

CELAMBARASAN

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Company:

     Load

                Name as CompanyName,

               fk_CompanyInformationId as CompanyInformationId,

     From

          Company.qvd;

Left Join(Company)

     Load

               CompanyInformationId,

               GLN

     From

          CompanyInformation.qvd;

QV automatically joins the table based on the common field name

Hope it helps

CELAMBARASAN

Not applicable
Author

Thanks,

That saved my day.