topic Re: Problem with the time stamps interval in QlikView

Problem with the time stamps interval

Anonymous — Tue, 01 Nov 2016 05:30:57 GMT

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.

Re: Problem with the time stamps interval

lakshmikandh — Tue, 01 Nov 2016 06:49:41 GMT

Calculate hours between two Date/Time strings

Re: Problem with the time stamps interval

jonathandienst — Tue, 01 Nov 2016 08:05:46 GMT

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.