3 Replies Latest reply: Oct 11, 2011 1:32 AM by vivek.singh RSS

    Peek Function Issue

      Hi,

       

      I am having some issue with Peek function.Here I have attached the document.

       

      In short the issue is -

       

      Initial table looks like

      NameloginDatelogoutDate
      bob

      10/01/2011 10.15 AM

      bob10/01/2011 10.30 AM
      bob10/03/2011 10.45 AM
      bob10/03/2011 11.00 AM
      bob10/06/2011 11.30 AM


      then I used the peek function on loginDate.

       

      Load *,

      Name

      logoutdate as logout,

      peek(loginDate) as login

      resident table;

       

      after this the table looked like

       

      nameloginlogout
      bob

      10/01/2011 10.15 AM

      10/01/2011 10.30 AM
      bob10/03/2011 10.45 AM10/03/2011 11.00 AM
      bob-

       

      The peek function couldn't read the last login record.(as there is no logout for that last login)

       

      can anyone help on this?Peek function reads the previous record.is there a way to read next record in qlikview?

       

      Thanks...