topic Script difference timestamp calculation in QlikView

Script difference timestamp calculation

Wed, 12 Feb 2014 16:13:35 GMT

Hi,

I load datas from a database, where there are several timestamps

example :

[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.

MyTable:

LOAD

Field,

DateDeparture,

DateArrival

Resident Table;

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

Re: Script difference timestamp calculation

Wed, 12 Feb 2014 16:18:21 GMT

Use the Previous or Peek functions to calculate the difference.

ArrivalTime - Previous(ArrivalTime)

Please post some sample source data so community will help more.

Re: Script difference timestamp calculation

Wed, 12 Feb 2014 16:29:33 GMT

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