topic Re: Subtracting 2 fields in QlikView

Subtracting 2 fields

Tue, 26 Jan 2016 06:37:41 GMT

Hi ;

I have two field that l want to subtract. [Last Drop Arrival Date] minus [First Pick Departure Date].

I am not getting any results when l subtract the 2 fields.

Please assist.

sunny_talwar — Tue, 26 Jan 2016 17:23:13 GMT

May be you need to help QlikView Understand you TimeStamp Fields using TimeStamp#() function

LOAD *,

[Last Drop Arrival Date] - [First Pick Departure Date] as TravelTime;

LOAD

TimeStamp#([First Pick Departure Date], 'DD/MM/YYYY hh:mm') as [First Pick Departure Date],

TimeStamp#([Last Drop Arrival Date], 'DD/MM/YYYY hh:mm') as [Last Drop Arrival Date]

FROM Source;

swuehl — Tue, 26 Jan 2016 17:25:48 GMT

SET TimestampFormat = 'DD/MM/YYYY hh:mm';

LOAD

[First Pick Departure Date],

[Last Drop Arrival Date],

Interval( [Last Drop Arrival Date]-[First Pick Departure Date]) as TravelTime,

Colin-Albert — Tue, 26 Jan 2016 17:28:21 GMT

Use the INTERVAL() function to calculate the difference between two time or date values.