3 Replies Latest reply: Nov 6, 2013 4:56 AM by adeel ahmed RSS

    Conditional Joining in Qlikview

      Hi,

       

      we have two below tables

      Table 1:

      ItemTariffStart DateEnd Date
      N001501-Jan-121-May-12
      N001551-May-1231-Dec-99

       

      Table 2:

      ItemMRDateQty
      N0013-Jan-125
      N0014-Feb-129
      N0016-May-1220

       

      Table 1 is tariff table and our tariff is expired on specific time and table 2 is our transnational table.

      We want to join them on the base of Item and MRdate which means that MRDate must lie between Start Date and End Date of Table2.

      If I create there query on SQL that is like { select a.Item, a.MRDate, a.Qty, b.Tariff from Table1 A join Table2 B on (a.item = b.item and a.MRDate between b."Start Date" and "End Date") }

      Please tell me how is it possible on qlikview.

      Our Result like that....

      Item

      MRDate

      Qty

      Tarif

      N001

      3-Jan-12

      5

      50

      N001

      4-Feb-12

      9

      50

      N001

      6-May-12

      20

      55

       

       

      Thank You