0 Replies Latest reply: Jan 19, 2017 3:13 AM by Saran Hari Ganesh RSS

    Auto increment in qliksense

    Saran Hari Ganesh

      hi everybody,

      @

      Kindly provide ideas/ways on how i can achieve this.
      we have a scenario where we have delivery date and maintenance date.
      Also, i have an input box to enter the no. of days(x).
      i would like to take a field from delivery date and add the days in variable and get D2.
      then i would like to add x to D2 and continue it as a loop till the count matched the last available maintenance date.

       

      eg: delivery date:1/6/2016   maintenance date count:4   input variable(days):30

       

      i want a field with expected date to be :01/07/2016
            30/08/2016
            01/09/2016
            31/09/2016

      thanks