topic Re: How to calculate time difference in QlikView? in QlikView

How to calculate time difference in QlikView?

ysj — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two fileds from QlikView session log i,e.,Timestamp,Session Start

i have calulate time difference in min,hours etc.

Please provide your thoughts.

Re: How to calculate time difference in QlikView?

sunny_talwar — Thu, 15 Jun 2017 13:26:05 GMT

Would you be able to provide this data in an Excel file? and also, what is the expected output?

Re: How to calculate time difference in QlikView?

stabben23 — Thu, 15 Jun 2017 13:32:58 GMT

Hi,

try to use Interval(Timestamp-"Session Start") in Your expression

Re: How to calculate time difference in QlikView?

antoniotiman — Thu, 15 Jun 2017 15:01:31 GMT

Hi,

try this

Time(TimeStamp#(Replace(SubField(Timestamp,'-',1),'T',' '),'YYYYMMDD hh:mm:ss.fff')
-
TimeStamp#(Replace(SubField([Session Start],'-',1),'T',' '),'YYYYMMDD hh:mm:ss.fff'))

e.g.

Time(TimeStamp#(Replace(SubField('20170531T07:20:57.000-0400','-',1),'T',' '),'YYYYMMDD hh:mm:ss.fff')
-
TimeStamp#(Replace(SubField('20170531T07:10:57.000-0400','-',1),'T',' '),'YYYYMMDD hh:mm:ss.fff')
)

--> 00:10:00

Regards,

Antonio