IF statements in load with Weekday

Anonymous — Mon, 14 Feb 2011 15:57:14 GMT

Hi - thanks in advance for any replies.

I use the following as part of a load script to recognise trading hours

(OOH is out of hours, INH is in hours)

I need the load to populate [DayShift] based on the following:

INH which is 8am-9pm Mon-Fri and 9am-5pm on Saturday. Any hours outside of this are OOH.

This is the load code I have tried but it does not load any INH, everything OOH - any ideas?

if(Weekday(DateLeadReceived) = 'Sat' AND time(timestamp(DateLeadReceived, 'YYYY-MM-DD hh:mm:ss.fff')) >= '09:00:00' AND time(timestamp(DateLeadReceived, 'YYYY-MM-DD hh:mm:ss.fff')) <= '17:00:00','INH',

(if((Weekday(DateLeadReceived) <> 'Sun' OR Weekday(DateLeadReceived) <> 'Sat') AND time(timestamp(DateLeadReceived, 'YYYY-MM-DD hh:mm:ss.fff')) >= '08:00:00' AND time(timestamp(DateLeadReceived, 'YYYY-MM-DD hh:mm:ss.fff')) <= '21:00:00','INH','OOH'))) as [DayShift],

IF statements in load with Weekday

Anonymous — Mon, 14 Feb 2011 16:07:04 GMT

I had a similar requirement and I resolved it using the IntervalMatch function. Please have a look at this useful function.

Regards,

Dinesh.

IF statements in load with Weekday

Anonymous — Mon, 14 Feb 2011 16:33:45 GMT

Thanks Dinesh

I have had a look at IntervalMatch but can't currently find anything that achieves what I would need

Could you post any code?

topic IF statements in load with Weekday in QlikView

IF statements in load with Weekday

IF statements in load with Weekday

IF statements in load with Weekday