Are the tables going to fight with each other...?

[Anonymous]

I have three tables loaded in the application as below. They are linked by "Order#" field.

1. OrderDtl Table: Order#, OrderQty, UnitPrice, OrderDate, etc (orders can be revised a couple of times requested by the customers and this will create multiple values under each Order#.

eg. Order#            OrderQty          UnitPrice         OrderDate

       12348               10                     5                    01/02/2013

       12348                -1                     5                    01/15/2013 (customer requested for one less product)

       12348               3                       5                     01/16/2013 (customer requested for 3 more products)

2. InvoiceDtl Table: Order#, OrderQty, ShipQty, Sales$, etc

3. SalesTerritory Table: Order#, TerritoryID, SalesRegionCode, etc

I am going to create a pivot table which will basically provide InvoiceDtl info by each Sales Territory, Year, Month, etc. In which circumstance the OrderDtl table will affect my result?

[alexandros17]

Sorry but I cannot understand your doubt ... can ypou explain better?

[puttemans · Accepted solution]

Hello Lynn,

If you are sure that the Order# field is correct in your 3 tables, then through the automatic association within Qlikview, there won't be any error. What I would do though to have only 1 key between all of your tables, is rename the OrderQty variable in table 1 or 2. That way, no automatic link will be made other than the one on Order#. It provides you also with an extra possibility to check, as I assume both variables (the original and the renamed one) should contain the same value for a single Order#.