Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hkg_qlik
Contributor II

Calendar (Net Working Days)

Hi,

I have been working on a Help desk management application. Until now I was using the regular calendar for reporting on the days the ticket was created to the date it was closed. The helpdesk department is closed on weekends and public holidays. So when a KPI is developed to calculate Avg. time duration for the ticket to get closed should also take into consideration while calculating weekends and public holidays, i.e. have to exclude those days when calculating:

(Ticket Created Date - Ticket Closed date)

Has anyone come accross such requirement or has an idea of how to design a calendar which takes this constrains into consideration?

Regards,

H

Community Browser