8 Replies Latest reply: Jan 28, 2016 2:23 PM by Sunny Talwar RSS

    Propagate values downwards

    Paul Johansson

      Hi all happy Qlikview people,

       

      I have a seemingly easy problem that i don't manage to solve.I want to populate the LastActiveWeek column downwards. I have been looking at Peek(). But since its impossible prehand to know how many rows I need to go back and check I cant get it to work.


      Starting Point:

      RegistrationDate

      Customer WeekDate LastActiveWeek
      2015-01-01794955011
      2015-01-0179495502
      2015-01-01794955033
      2015-01-0179495504
      2015-01-01794955055
      2015-01-0179495506
      2015-01-0179495507
      2015-01-017949550

      8

      2015-01-0179495509
      2015-01-01794955010

       

       

       

      Goal:

      RegistrationDate

      CustomerWeekDateLastActiveWeek
      2015-01-01794955011
      2015-01-01794955021
      2015-01-01794955033
      2015-01-01794955043
      2015-01-01794955055
      2015-01-01794955065
      2015-01-01794955075
      2015-01-017949550

      8

      5
      2015-01-01794955095
      2015-01-017949550105

       

      What would the recommended technique be? Any guidance or ideas are very much appreciated.

       

      Thanks in advance,

      Br

      Paul

       

      Message was edited by: Paul Johansson