3 Replies Latest reply: Nov 25, 2014 6:09 AM by Marco Wedel RSS

    join table

    Paolo Guidolin

      hi,

      i'm new in qlik view and i have the following problem.

      I have two table, one with document date and price

       

                             

      doc dateprize
      01/02/20141
      04/04/20142
      15/05/20142,2
      05/06/20142,5

       

      and another with quotation date and quotation value

       

                                 

      quotation
        date
      value quotation
      01/01/20145
      15/02/20146
      03/03/20147
      03/04/20148
      05/05/20149

       

      I need to join the two tables in order to obtain

       

      doc dateprize last value   quotation     with date <= doc date
      01/02/201415
      04/04/201428
      15/05/20142,29
      05/06/20142,5

      9

       

       

      can someone help me?

       

      Thanks