Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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