Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | ClosedDate | 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?
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
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
Thanks,
That saved my day.