2 Replies Latest reply: Jan 6, 2017 5:43 AM by Vegar Lie Arntsen RSS

    How to write sequence order as date.

    Jasobanta Pradhan

      Hi ,

      I have source table T1.



        Date,       Amount
      04/01/2016, 10
      04/01/2016, 10
      04/01/2016, 10
      04/01/2016, 30
      04/02/2016, 10
      04/02/2016, 20





        Date,         Amount,    Entryno
      04/01/2016,   10 ,        1
      04/01/2016,   10,         2
      04/01/2016,   10,         3
      04/01/2016,   30,         4
      04/02/2016,   10,         1
      04/02/2016,   20,          2


      Its different two dates.

      Help in script...



        • Re: How to write sequence order as date.
          Vegar Lie Arntsen

          I've not verified that this will work hence I am away of my computer, but give autonumber a try.


          Assuming you have a rowId (primary key) in your table then this might work.





          Autonumber(rowId, Date) as EntryNo

          Resident T1;

          Med vänlig hälsning, Vegar Lie Arntsen  



          Sent from my Oneplus using K-9 Mail. Please excuse my brevity.

          • Re: How to write sequence order as date.
            Vegar Lie Arntsen

            I did a test and it should work.








            Vegar Lie Arntsen





            When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.