topic Calculating time between Two time stamp in QlikView

Calculating time between Two time stamp

Thu, 20 Nov 2014 08:59:57 GMT

hey guys I am new to qlikview .

Can you please help me to calculate the no of working days,hours , minutes , to close the case.

tresB — Thu, 20 Nov 2014 09:05:30 GMT

Try interval()

Thu, 20 Nov 2014 09:12:49 GMT

Hi,

you can try the below format, in which the vale return are the number of days

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns:

see Qlikview help for further explanation

with regards

Harshita Gaur