2 Replies Latest reply: Jun 26, 2017 7:42 PM by Marco Wedel RSS

    how to get minimum and maximum date from multiple table

    vir vir

      Hi,

       

      I have 1 requirement where i have below given tables:

      • Contact_F
      • Contact_Details
      • Contact_Address
      • Contact_Emails
      • Contact_References

       

      all tale having field called created_date and modified_date.

       

      now i want to get Minimum created date from comparing to all 5 tables and maximum modified_date comparing all 5 table.

      For example:

      Contact_F

      -----------------

      Cotact WID , Created_date,Modified_Date

      RMG01       , 2017/06/05, 2017/06/21


      Contact_Details

      -----------------

      Cotact WID , Created_date,Modified_Date

      RMG01       , 2017/06/05, 2017/06/22


      Contact_Address

      -----------------

      Cotact WID , Created_date,Modified_Date

      RMG01       , 2017/06/04, 2017/06/21


      Contact_Emails

       

      -----------------

      Cotact WID , Created_date,Modified_Date

      RMG01       , 2017/06/02, 2017/06/21


      Contact_References

      -----------------

      Cotact WID , Created_date,Modified_Date

      RMG01       , 2017/06/02, 2017/06/18


      As per above tables the minimum created_date is 2017/06/02 and maximum modified_date is 2017/06/22.

      please suggets how to get minimum created date and maximum Modified date from above tables .

      later i need to left join all tables with Contact_f.


      this minimum created_date and maximum Modified_date will further use for query filter in Qlik script.

       

       

      Please suggest