Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
shashank20
New Contributor III

Problem with the time stamps interval

Hi Geniuses,

I have two time stamps

Open_Timestamp --> When the ticket opens

Close_Timestamp --> When the ticket closes

I want to find out that how much hours it took to close the ticket, I have to exclude the Friday and Saturday of the week from the calculation(As friday sat is weekend here )

Please help me.

Thanks in advance.

S

2 Replies
lakshmikandh
Valued Contributor II

Re: Problem with the time stamps interval

MVP
MVP

Re: Problem with the time stamps interval

Unfortunately, the working day calculations in QV have a fixed weekend of Saturday and Sunday, so you will have to roll your own.

What I would do is include a working day as a field in your calendar, having a value of zero for Fridays and Saturdays and 1 for working days. You could then sum working days to get a NetWorkDay equivalent that you could then plug into the suggestions in the link above.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein