topic Re: Date interval in QlikView

Date interval

Wed, 06 Apr 2016 07:44:45 GMT

suppose, I have a start date and a end date value. how do I get the duration by the interval function or if there is any other option?

example :

start time : 10:20:00 AM

end time : 2:20:00 PM

My desire output be like , Total hours : 4:00:00

Please help me.

tamilarasu — Wed, 06 Apr 2016 08:19:30 GMT

Hi,

try,

Expression:

Interval( Timestamp#([end time], 'hh:mm:ss tt') - Timestamp#([start time],'hh:mm:ss tt') , 'hh:mm:ss')

Load Script:

Load *,

Interval( Timestamp#([end time], 'hh:mm:ss tt') - Timestamp#([start time],'hh:mm:ss tt') , 'hh:mm:ss') as Interval

From Source;

qlikvfpi — Wed, 06 Apr 2016 08:20:42 GMT

Maybe like this :

=date(num(date('11:00','hh:mm'))-num(date('09:00','hh:mm')),'hh:mm')

Chanty4u — Wed, 06 Apr 2016 08:21:09 GMT

try this

am not sure

=Interval( Timestamp#([End Time], 'hh:mm:ss TT') - Timestamp#([Start Time],'hh:mm:ss TT') , 'hh:mm:ss')

Kushal_Chawda — Wed, 06 Apr 2016 08:23:54 GMT

=Time(frac(Time#([end time],'hh:mm:ss TT') -Time#([start time],'hh:mm:ss TT')),'hh:mm:ss')