9 Replies Latest reply: Jun 19, 2018 8:00 PM by Sunny Talwar RSS

    Identifying First entry date

    Jeremiah Bakerstull

      I'm trying to create a column in a table that would identify the first date within client that have multiple entries.

       

           This is what the date looks below.

       

      Client IdEntry Exit Provider NameEntry DateExit Date AdjustedTest
      758LSS - FM Faith on 6th3/22/20184/5/201820180322
      758LSS - FM Faith on 6th4/26/20186/4/201820180426
      2134LSS - FM Faith on 6th3/30/20186/15/201820180330
      2517LSS - FM Faith on 6th3/9/20185/9/201820180309
      4586LSS - FM Nancy's Place2/10/20186/18/201820180210
      4587LSS - FM Nancy's Place2/19/20185/4/201820180219
      5128LSS - FM Nancy's Place5/19/20186/4/201820180519

       

      My desire result would be:

      Client IdEntry Exit Provider NameEntry DateExit Date AdjustedTest
      758LSS - FM Faith on 6th3/22/20184/5/2018Fist
      758LSS - FM Faith on 6th4/26/20186/4/2018
      2134LSS - FM Faith on 6th3/30/20186/15/2018First
      2517LSS - FM Faith on 6th3/9/20185/9/2018First
      4586LSS - FM Nancy's Place2/10/20186/18/2018First
      4586LSS - FM Nancy's Place2/19/20185/4/2018
      5128LSS - FM Nancy's Place5/19/20186/4/2018First

       

      I've seen few of examples but I'm still learning the syntax structure of Qlik and it's hard to apply wihtou knowing what thte formula's are doing.

       

      Thanks.