0 Replies Latest reply: Jun 16, 2015 6:15 AM by klaas bos RSS

    How to connect a Cross table with a 'normal' table?

      Hello everyone,


      I'm new to qlikview so I want to I introduce myself.


      I'm from the Netherlands and I'm experimenting with Qlikview now for about 3 months. I'm working in a production company where we are producing Automotive Parts such as doors etc. We are working with SAP.


      I want to make a dashboard where we can show a combined result (Commercial Result and Production Result together).

      I'm experiencing the following problem. I have two tables wich i want to connect:


      1. Commercial result, is structured as follows (collumns):


              Materialnr, Turnoverdate, Turnover, costs, result,


          2. Production result, is structured as follows (collumns):


      Materialnr, result period 1 , result periode 2, result period 3, entc..


      So I made a crosstable so that the structure of the tables is the same.


      How can I use the attibute field (period) from my crosstable in a key? I want to connect the two tables with a key such as 'Material-Year-Period'.


      Hope I explained my problem well.