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)
Thank you for your reply. I have the following load:
[Serial No] as [SerialNo],
I have the energy in 15 minute intervals in .xls in the datetime field. (Let us say I have Energy as 80 in 1/13/2014 15:00 and 78 in 1/13/2014 14:45. I want to calculate the energy in the interval i.e. 80 - 78).
How do I access the Energy field in the previous(datetime) record?
previous(datetime) will give you the previous record datetime and Previous(Energy) will give you the previous record energy. Please explain what you exactly want to calculate the energy in the interval i.e. 80 - 78. Can you come with an example and sample file.