Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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#.
Sorry but I cannot understand your doubt ... can ypou explain better?
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#.