I was wondering if someone would be able to help me with this query. I am new to Qlikview and have created a straight chart where all my information goes into. I have created a new column which I called Time (log-close).
In that new column I want to be able to calculate in hours, the difference between a field called closedate(which is a date/time field 01/01/2010 09:00:00) and a field called logdate (which is also a date time field 01/01/2010 09:00:00).
To calculate the difference I used the following expression: Interval (closedate - logdate), which gave me the correct hours:minutes:seconds.
However our business hours are only between 08:00 - 18:00. Therefore if we had the example 1 below, at the moment the hours would show as 49:00:00. However as we are not interested in time before 08:00 and after 18:00, the correct time should show as 20:00:00.
To make matters more complicated we are also not interested in weekends, therefore in example 2, the way we currently have it the hours would show as 66:00:00 (as the dates are over the weekend), however the correct time should show as 04:00:00 (as this will ignore times after 18:00 and also the whole of Saturday and Sunday).
