topic Joining tables in QlikView

Joining tables

Wed, 12 Oct 2011 13:37:11 GMT

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

I have 4 tables:

SalesHeader	SalesDetails	OrderHeader	OrderDetails
F1FANR	F2FANR as F1FANR	KEORNR as OrderNumber	KAORNR as OrderNumber
F1FADT as Date	F2FADT	KELIJN as OrderLineNumber	KAFACN
F1MUNT	F2ORNR as OrderNumber	KECODE	KAKNUM
F1KNUM	F2LIJN as OrderLineNumber	KEAANT	KACRED as Date
F1FACN	F2CODE	KEPRIX	KAMUNT
F1VERT	F2TFAK	KEFIFO	KAMULT
	F2BOEK	KEFISC
	F2PRIX	KEKOMS
		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

Joining tables

Wed, 12 Oct 2011 13:47:51 GMT

SalesHeader	SalesDetails	OrderHeader	OrderDetails
F1FANR	F2FANR as F1FANR	KEORNR as OrderNumber1 KEORNR as OrderNumber2	KAORNR as OrderNumber1
F1FADT as Date	F2FADT	KELIJN as OrderLineNumber	KAFACN
F1MUNT	F2ORNR as OrderNumber2	KECODE	KAKNUM
F1KNUM	F2LIJN as OrderLineNumber	KEAANT	KACRED as Date
F1FACN	F2CODE	KEPRIX	KAMUNT
F1VERT	F2TFAK	KEFIFO	KAMULT
	F2BOEK	KEFISC
	F2PRIX	KEKOMS
		KEKITR

Try this?

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

Joining tables

Wed, 12 Oct 2011 13:56:33 GMT

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