6 Replies Latest reply: Jan 13, 2014 8:23 AM by Jonathan Dienst RSS

    Looking up a previous row in an Excel sheet

      Hi,

       

      I have a time series energy data in an Excel spreadsheet with intervals of 15 minutes. I will need to compare 2 rows to get the energy produced in the interval. In Qlikview, how do I access a previous record? I have a datetime field with date and time (15 minute intervals)

       

      Thanks

      -Sri