topic Adjusted Time Intervals for Working Hours in QlikView

Adjusted Time Intervals for Working Hours

Mon, 07 Nov 2011 16:04:56 GMT

Hello Everyone --

I'm new to Qlikview and need the expertise of this community to help me out in coming up with an "adjusted" time interval that takes into account actual work hours. Our "work hours" would start from 8:00am and would not include a one hour lunch starting at noon time and needs to account for a 15 minute break starting at 3:00.

I'm looking to come up with a time interval between a start date and an end date that takes these working day parameters into account. Here is the breakdown of what i'm looking for:

1. If the start time is before 8:00am, default the start time to 8:00am.

2. If the start time is before noon, and the end time is after 1:00pm, subtract 1 hour.

3. If the start time is before 3:00pm and the end time is after 3:15pm, subtract 15 minutes (break time)

I tried doing this through the use of If statements and I could not get this working. Any help would be much, much appreciated and as I learn more about Qlikview I will definitely be a contributor to this forum.

Thanks,

Jim

Adjusted Time Intervals for Working Hours

kamalqlik — Tue, 08 Nov 2011 05:38:01 GMT

Hi Friend I am not to sure ...but you can try with the help of interval match.....You can learn about interval match in qlikcommunity and refrence mannual.....Try to learn about that.In case you face any problem...you can get back to me..again

regards

Kamal

Adjusted Time Intervals for Working Hours

Tue, 08 Nov 2011 11:15:35 GMT

on the below link you will get how to create time ranges from 00:00 to 23:59.

http://community.qlik.com/message/30241#30241

after creating time ranges you can use interval match concept to calculate total working hours.

if you get any problem after applying that then revert back to me.

regards

vijit