3 Replies Latest reply: Nov 16, 2016 1:36 AM by Rendi Yanuar RSS

    [ASK] read next row data as a new column

    Rendi Yanuar

      Hi Qlik Masters,

       

      i have a table that show target based on date, example below :

      BRANCHTARGETSTART_DATE
      A501-JAN-2016
      A701-FEB-2016
      B301-MAR-2016
      B701-APR-2016

       

      Based on above data, i don't have END_DATE and user expect me to set end_date from next start_date, if next start_date null then today.

      Show the result will be like below :

      BRANCHTARGETSTART_DATEEND_DATE
      A501-JAN-201631-JAN-2016
      A701-FEB-201616-NOV-2016
      B301-MAR-201631-MAR-2016
      B701-APR-201616-NOV-2016

       

       

      Based on above example, is there any solution to do that in load script?

       

      Many thank you,

      Best Regards