Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Join issue

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

2 Replies

Re: Join issue

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

Join issue

Thanks,

That saved my day.