Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 No | User | Case Created | Case Closed |
1 | abc1 | 19/11/2014 11:45 | 29/11/2014 12:50 |
2 | abc2 | 19/11/2014 16:30 | 19/11/2014 17:18 |
3 | abc3 | 24/11/2014 11:45 | 27/11/2014 12:25 |
4 | abc4 | 19/11/2014 08:30 | 19/11/2014 11:50 |
5 | abc5 | 22/11/2014 14:30 | 24/11/2014 15:30 |
6 | abc6 | 19/11/2014 19:15 | |
7 | abc7 | 20/11/2014 16:05 | 20/11/2014 17:00 |
8 | abc8 | 20/11/2014 16:05 | 21/11/2014 12:00 |
9 | abc9 | 27/11/2014 12:30 | 28/11/2014 11:30 |
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