1 Reply Latest reply: Oct 10, 2017 5:00 AM by Chris Wong RSS

    Qlik Sense - Link table based on calculated field from multiple tables

    Chris Wong

      Dear Expert,

      how can i Link table based on calculated field(Age) and retrieve yield(Mt/Ha)?

      Attached excel and qvf file.

       

      Capture.PNG

       

       

      1) Table 1: Year of Planting

      Location L1 year of planting is 2006

      Capture.PNG

      2) Table 2: Data

      Age(Calculated field) = fiscal year - year of planting

      Location: L1

      From Sep- 11 till Aug-12,  age is 6

      From Sep- 12 till Aug-13,  age is 7

      Capture.PNG

       

      3) table 3: benchmark

      Capture.PNG