2 Replies Latest reply: Nov 25, 2013 1:06 PM by Steve Zagzebski RSS

    Between in QlikView

    Steve Zagzebski

      I need to left join the F_Revenue table to the Dept_Activation table by the Dept field AND where the Service Date on the F_Revenue table is between the Active_Begin_Date and Active_End_Date. Looking for help on how to code the where clause to make this happen?

       

      F_Revenue:

      Dept,

      Revenue,

      Service Date

      Resident Revenue

       

      Left Join (F_Revenue)

      Dept

      Active_Begin_Date

      Active_End_Date

      Resident Dept

      WHERE

       

      Thanks,

       

      Steve