Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lynnmiao
Contributor II
Contributor II

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

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?

1 Solution

Accepted Solutions
puttemans
Specialist
Specialist

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#.

View solution in original post

2 Replies
alexandros17

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

puttemans
Specialist
Specialist

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#.

View solution in original post