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

Joining tables

I am new to QlikView and now facing problems to perform margin analysis due to failure to join tables.

I have 4 tables:

SalesHeaderSalesDetailsOrderHeaderOrderDetails
F1FANRF2FANR as F1FANRKEORNR as OrderNumberKAORNR as OrderNumber
F1FADT as DateF2FADTKELIJN as OrderLineNumberKAFACN
F1MUNTF2ORNR as OrderNumberKECODEKAKNUM
F1KNUMF2LIJN as OrderLineNumberKEAANTKACRED as Date
F1FACNF2CODEKEPRIXKAMUNT
F1VERTF2TFAKKEFIFOKAMULT
F2BOEKKEFISC
F2PRIXKEKOMS
KEKITR

To calculate the margin, I need F2TFAK*F2PRIX - F2TFAK*KEFIFO

I do not succeed in joining the tabels correctly. 

When I look at the table viewer, I get values for the fields of the tables 'SalesHeader' and 'SalesDetails', but not for the 'OrderHeader' and 'OrderDetails' tables (I joined the tables using 'left join').

Any suggestions to resolve my problem ?

Many thanks !

Davy

2 Replies
Not applicable

Joining tables

SalesHeaderSalesDetailsOrderHeaderOrderDetails
F1FANRF2FANR as F1FANR

KEORNR as OrderNumber1

KEORNR as OrderNumber2

KAORNR as OrderNumber1
F1FADT as DateF2FADTKELIJN as OrderLineNumberKAFACN
F1MUNTF2ORNR as OrderNumber2KECODEKAKNUM
F1KNUMF2LIJN as OrderLineNumberKEAANTKACRED as Date
F1FACNF2CODEKEPRIXKAMUNT
F1VERTF2TFAKKEFIFOKAMULT

F2BOEKKEFISC

F2PRIXKEKOMS


KEKITR




  Try this?

Can you share a image of how the table joins look?

Not applicable

Joining tables

Name AS,(Rename fields) then use them to link,Comment out and copy for backup in case something happens,

If u can mess with the source of this sheet...(If excel)then add something with the same name in each table as in:

FRONT then next table would be FRONT-2 etc....

U can use that to see how u will structure ur joins,its a lot simpler but different things work for different people,goodluck mate

Community Browser