7 Replies Latest reply: Sep 5, 2014 10:31 AM by Preciliano Fausto RSS

    Relationship between table Qlikview

      If I have the following tables

       

      Discounts:

            Date_Discount      Rate

            2014.04.01              10

            2014.04.02              11

            2014.04.05                9

            2014.04.06              12

       

       

      Sales:

            Sales_Date           Amount

             2014.04.01            100

             2014.04.02            120

             2014.04.03              80

             2014.04.04              90

             2014.04.05              95

             2014.04.06             110

             2014.04.07             125

       

      How could i get the following table?

       

            Sales_Date        Amount        Rate

             2014.04.01            100             10

             2014.04.02            120             11

             2014.04.03              80             11

             2014.04.04              90             11

             2014.04.05              95               9

             2014.04.06            110             12

             2014.04.07            125             12