topic Re: 15 mints time difference need to identify in QlikView

15 mints time difference need to identify

Anonymous — Tue, 24 Mar 2015 06:01:28 GMT

I have a field which is capturing invoice time daily basis like this 10.30.22, 10.40.21,

My requirement is need to identify the 15 mints time difference in the invoice time field.

Example: first row 11.30.22 ,

second row 11.45.40

i need to get the difference like this 00.15.18

How can i achieve this kindly help me

Thanks in Advance..

Siraj

hic — Tue, 24 Mar 2015 06:09:11 GMT

Make sure that the timestamps are ordered, and use

Load

Time#( TimeStamp, 'hh.mm.ss' ) as Time,

Time(Peek(Time) - Time#( TimeStamp, 'hh.mm.ss' )) as Diff,

HIC

danieloberbilli — Tue, 24 Mar 2015 06:09:25 GMT

PFA the qvw

amit_saini — Tue, 24 Mar 2015 06:14:22 GMT

Hi,

Check :

Thanks,
AS

Anonymous — Tue, 24 Mar 2015 08:35:44 GMT

Thanks for your answer

i here attached my sample data can you kindly help me to fix this in my file

please find the attachment.

danieloberbilli — Tue, 24 Mar 2015 12:59:38 GMT

PFA

Kind Regards

Daniel

Anonymous — Tue, 24 Mar 2015 14:20:07 GMT

Thanks lot...

working fine..