Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating time between Two time stamp

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.

Ticket NoCase CreatedCase ClosedUser
01/01/190019/11/2014 11:4529/11/2014 12:45abc1
02/01/190019/11/2014 16:3019/11/2014 17:30abc2
03/01/190024/11/2014 11:4527/11/2014 12:45abc3
04/01/190019/11/2014 08:3019/11/2014 11:30abc4
05/01/190022/11/2014 14:3024/11/2014 15:30abc5
06/01/190019/11/2014 19:15abc6
2 Replies
tresesco
MVP
MVP

Try interval()

Not applicable
Author

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:

   

String

365 09:00

Number

365.375 

see Qlikview help for further explanation

with regards

Harshita Gaur