6 Replies Latest reply: Jan 9, 2015 11:17 AM by Christoph Krieg RSS

    Join three tables with different fields

      Hello all,

       

      I'm new with Qlikview and don't know how to go on now.

       

      I got three tables:

       

      KST:

      CostCenterNumber

      CostCenterDescription

       

      DATA:

      CostCenterDescription

      Value1

      Value2

       

      WorkedHours:

      CostCenterNumber

      HoursWorked

       

      I need to link DATA (includes sales etc.) with WorkedHours to now how many hours used for made sales. Problem is, that I got CostCenterNumber in the WorkedHours and CostCenterDescription in the Data, the translation is in KST.

      How do I have to script that?

      The three tables come from Excel.

       

      Many thanks for your help in advance!

      Christoph