7 Replies Latest reply: Apr 18, 2018 6:20 AM by Pedro Gomes RSS

    Discover minimum date for each day, for each user

    Pedro Gomes

      Hello,

       

      I am struggling with finding a way to know the minimum date of each day for each user in QlikSense

       

      This is the data I have: (date of login is M/D/YYYY)

      user iddate of loginrecord type
      3031/2/2017 1:04:24 PMtype1
      3031/2/2017 2:01:39 PMtype1
      3031/2/2017 2:03:31 PMtype1
      8081/3/2017 1:02:21 PMtype1
      8081/4/2017 4:04:24 PMtype1

       

      What I want to get is the following:

      user iddate of loginrecord type
      3031/2/2017 1:04:24 PMtype1
      8081/3/2017 1:02:21 PMtype1
      8081/4/2017 4:04:24 PMtype1

       

       

      Thank you in advance