Discussion Board for collaboration related to QlikView App Development.
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".
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])