How to calculate time difference in QlikView?

[ysj]

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.

[sunny_talwar]

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

[stabben23]

Hi,

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

[antoniotiman]

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