Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating time to close the case

Hey guys,

I attached a file and want to calculate the no of days, hours and minutes took to close the case in different column in qlikview excluding the weekends . And status as "Closed" or "Pending".

The field which is blank will be the today's time and status will be as "Pending".

Ticket NoUser Case CreatedCase Closed
1abc119/11/2014 11:4529/11/2014 12:50
2abc219/11/2014 16:3019/11/2014 17:18
3abc324/11/2014 11:4527/11/2014 12:25
4abc419/11/2014 08:3019/11/2014 11:50
5abc522/11/2014 14:3024/11/2014 15:30
6abc619/11/2014 19:15
7abc720/11/2014 16:0520/11/2014 17:00
8abc820/11/2014 16:0521/11/2014 12:00
9abc927/11/2014 12:3028/11/2014 11:30
1 Reply
MVP & Luminary
MVP & Luminary

To exclude the weekends you could use networkdays():

networkdays(floor([Case Created]), floor([Case Closed]))

and then adds the time:

frac([Case Closed]) - frac([Case Created])

- Marcus