5 Replies Latest reply: May 18, 2012 4:10 AM by Anosh Nathaniel RSS

    concatenated tables problem

    Sonika Jain

      Dear all,

       

      I have two inline tables concatenated in my data model. These have 2 columns B,C common amongst A B C D.
      Now, for some reason, I want to find the sum of D for each A.

       

      I know this may be one of the basic concepts, but am new to Qlikview, and am struggling with it.Please help. Sample QVW file also attached.

      Sample Data:

      [table1]:
      LOAD * INLINE [
      A, B, C
      1, 2, 3
      4, 5, 6
      7, 8, 9
      10, 11, 12
      1, 2, 3
      ];

      Concatenate
      LOAD * INLINE [
      B, C, D
      2, 3, 20
      5, 6, 21
      8, 9, 22
      11, 12, 23
      2, 3, 24
      7, 8, 25
      9 , 10, 26
      ];

      Suggestions awaited.
      Thanks in Advance.