2 Replies Latest reply: Aug 30, 2017 2:26 AM by FARRUKH ZUBAIR RSS

    Creating new field using different tables.

    FARRUKH ZUBAIR

      Dear Experts,

       

      I am new to qlikview and I am struggling to reach a solution but end up with no success. I have two tables e. g as below:

       

      A:

       

      LOAD * INLINE [

          ID, C

          3, 23

          4, 45

          5, 67

      ];

       

      B:

      LOAD * INLINE [

          ID, A, B

          1, FHF, 99

          3, GFHF, 900

          4, TRYR, 800

          7, ERW, 250

      ];

       

      I want new filed as "D" calculating "B+C". "B" from table B: and "C" from A: Please assist.

       

      Farrukh