1 Reply Latest reply: Aug 29, 2011 11:49 AM by Sunil Chauhan RSS

    Next record in qlik view

      Hi All,

       

      Below is the data in the table.

       

      NameDateTimeCodeEvent
      JON8/8/20112.50.00 PMRRRConnect
      JON8/8/20112.50.00 PMXXXNot Active
      JON8/8/20112.51.00 PMBBBActive
      JON8/8/20112.53.00 PMZZZNot Active
      JON8/8/20112.53.20 PMCCCNot Active
      JON8/8/20112.53.40 PMDDDNot Active
      JON8/8/20112.55.00 PMDDDDisconnect
      JON8/8/20113.10.00 PMRRRConnect
      JON8/8/20113.11.00 PMXXXNot Active
      JON8/8/20113.15:00 PMDDDDisconnect


      Try to find out for how long Jon was in 'Not active' state group by code.Final result would be

      CodeDuration
      XXX00:05:00
      ZZZ00:02:00


      In my script, I have to find out where the event is 'not active'  and capture the corresponding time as start time and then need to go to the next record to find out what the event value is,if the event  is other than 'Not active' then only I have to pick the corresponding time as end time.if the next record has event as 'not active' have to check next records till the value is either active or disconnect.Finally have to substract start time from end time to know how long the person is in 'not active' state.For final calculation need to do a group by on code.

       

       

      Can any one know how to go to next record in qlikview? Any idea how to do this in script?

       

      thanks.