Join issue

Thu, 16 Feb 2012 08:59:16 GMT

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

Name	Phone	CreatedDate	fk_CompanyInformationId
A	555-103-000	19.01.2007	1
B	555-103-001	25.08.2003	2
C	555-103-002	30.01.2001	4
D	555-103-003	16.05.2007	5

CompanyInformation.qvd contains

CompanyInformationId	GLN	ContactName
1	7080000000100	Torgersen
2	7080000000120	Rahmanian
3	7080000000125	Evje
4	7080000000178	Jansson
5	7080000000183	Olsen
6	7080000000210	Myrhaug
7	7080000000325	Brunner

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

CompanyInformationId	GLN	CompanyName
1	7080000000100	A
2	7080000000120	B
4	7080000000178	C
5	7080000000183	D

Any suggestions?

Re: Join issue

CELAMBARASAN — Thu, 16 Feb 2012 09:06:18 GMT

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

Join issue

Thu, 16 Feb 2012 09:50:55 GMT

Thanks,

That saved my day.

topic Join issue in QlikView

Join issue

Re: Join issue

Join issue