0 Replies Latest reply: Nov 27, 2017 3:09 PM by Prasad Mundewadi RSS

    2 Dim 2 measure need to be combined in 1 chart

    Prasad Mundewadi

      Hello Qlik

      I am trying to get a result can anybody help me here?

       

      //2 Data sets below

      Table1:

      load * Inline

      [

      Day1,Measure1

      1,20

      2,30

      3,50

      4,25

      5,45

      ];

       

      Table2:

      load * Inline

      [

      Day2,Measure2

      1,50

      2,40

      3,30

      4,20

      5,10

      ];

       

      -------------------------------

      Note: Day1 and Day2 are different dimensions here.

      Need to get a resultant table as Day and sum of the 2 measures from 2 tables above.

      Day     Measure

      1          70 (20+50)

      2          70 (30+40.. ans so on)

      3          80

      4          45

      5          55