17 Replies Latest reply: Jun 2, 2016 3:06 AM by Mindaugas Bacius RSS

    Cannot properly connect data. Set analysis issue

    Mindaugas Bacius

      Hei

       

      There are two tables.

       

      First table:

      AmountDateKey
      1002016-01-301
      2002016-02-281
      3002016-03-312
      502016-04-302

       

      Second table:

      KeyDate2Value
      12016-03-3010
      12016-03-3120
      12016-04-0130
      22016-03-3015
      22016-03-3125
      22016-04-0135

       

       

      1. Pick up all Amount fields where Date <= 2016-03-31.
      2. Find the Date2 = 2016-03-31 and connect Value to the First table.
      3. Make aggregation Amount * Value.

       

      I was struggling to accomplish this task by using Set analysis.

      Please find the qvw.

       

      Thank you!