topic Re: Exp Help in QlikView

Exp Help

abhaysingh — Mon, 28 Sep 2015 10:55:04 GMT

HI All,

I have two Time Value

Time1 Time 2 Difference = Time1 - Time2

10:43:36 AM 10:22:00 AM Ouput Required in Seconds

I am simply Doing Time1-Time2 and Getting output 175.98499988425;

expected output is 21:36 Minutes... Final result want in seconds

Please Suggest

Abhay

Re: Exp Help

sunny_talwar — Mon, 28 Sep 2015 10:58:00 GMT

Try this:

Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 'mm:ss')

Re: Exp Help

sasiparupudi1 — Mon, 28 Sep 2015 11:03:17 GMT

=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')

Re: Exp Help

qlikmsg4u — Mon, 28 Sep 2015 11:03:49 GMT

=Interval(Time#('10:43:36 AM','hh:mm:ss tt')-Time#('10:22:00 AM','hh:mm:ss tt'),'mm:ss')

=Interval(Time#('10:43:36 AM','hh:mm:ss tt')-Time#('10:22:00 AM','hh:mm:ss tt'),'ss')&' Seconds'

Re: Exp Help

abhaysingh — Mon, 28 Sep 2015 11:24:04 GMT

HI,

Not Working

Interval(Time#(Time1Field, 'hh:mm:ss TT') - Time#(Time2Field, 'hh:mm:ss TT'), 's')

regards

Abhay

Re: Exp Help

Anonymous — Mon, 28 Sep 2015 11:34:52 GMT

Hi try this,

Interval(Time#(Time1)-Time#(Time2),'hh:mm:ss') as TimeDiff

Re: Exp Help

sunny_talwar — Mon, 28 Sep 2015 11:35:19 GMT

See if this is what you want:

Expression: =Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 'mm:ss')

Re: Exp Help

Digvijay_Singh — Mon, 28 Sep 2015 11:37:09 GMT

Not sure though but It seems your time fields are of Timestamp type else suggested solution would have worked. May be Try Frac() before Time# function.

Re: Exp Help

Mon, 28 Sep 2015 11:44:46 GMT

Hi Abhay,

Go to Number tab,

Choose the format of Time1, Time2, and Difference (TIme1-Time-2) as Time in Number tab.

Regards,

Pavan.

Re: Exp Help

abhaysingh — Mon, 28 Sep 2015 13:27:19 GMT

I m trying below

Interval((Time(DateRecorded_Test, 'hh:mm:ss TT')) - (Time(UTC_World_TIme, 'hh:mm:ss TT')), 'mm:ss')

Regards

Abhay

Re: Exp Help

jonathandienst — Mon, 28 Sep 2015 13:32:18 GMT

Time in minutes:

(Frac(Time1) - Frac(Time2)) * 1440

Time in seconds:

(Frac(Time1) - Frac(Time2)) * 1440 * 60

Re: Exp Help

jonathandienst — Mon, 28 Sep 2015 13:34:00 GMT

>>175.98499988425

There are 176 days between these two timestamps. Are you sure the simple difference in minutes is meaningful?

Re: Exp Help

pratap6699 — Mon, 28 Sep 2015 17:42:04 GMT

by differenciate time interals we use interval function

=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')