Discussion Board for collaboration on QlikView Scripting.
I load datas from a database, where there are several timestamps
[Field 1] [Date/Time Departure 1] [Date/Time Arrival 1],
[Field 2] [Date/Time Departure 2] [Date/Time Arrival 2],
[Field 3] [Date/Time Departure 3] [Date/Time Arrival 3], etc.
I want to add a field TimeStampDiff which is the lapstime in minutes between [Date/Time Departure 2] and [Date/Time Arrival 1], [Date/Time Departure 3] and [Date/Time Arrival 2]
In general [Date/Time Departure n+1] and [Date/Time Arrival n]
How can I do it in script ?
Thanks in advance for your help
Go to Solution.
Use the Previous or Peek functions to calculate the difference.
ArrivalTime - Previous(ArrivalTime)
Please post some sample source data so community will help more.
Thank you, it seems to work !
I'll try next time to add sources. Please see my other topic : Filter a table object with a calendar