topic Re: Shift Allocation Based on Reload time in QlikView

Shift Allocation Based on Reload time

anuradhaa — Fri, 06 Nov 2015 09:31:28 GMT

I have Attached data.

i need to categorized those data based on shifts.

Shift 1	6:30	14:30
Shift 2	14:30	22:30
Shift 3	22:30	6:30

Here i want to consider times for most recent shifts based on reload time.

If the reload time is 07:00 AM 2015/11/06

my shifts should be

Shift 1 - 2015/11/05 22:30 - 2015/11/06 06:30

Shift 2 - 2015/11/05 14:30 - 2015/11/06 22:30

Shift 3 - 2015/11/05 06:30 - 2015/11/06 14:30

Hope you are clear with my requirement. I have reload this every hour

Re: Shift Allocation Based on Reload time

miguelbraga — Fri, 06 Nov 2015 09:50:23 GMT

Hey Anuradha,

You can do it something like this:

if([shift field] = 1, (Date(ReloadTime(), 'DD/MM/YYYY') - 1) & ' ' & [start hour field] & ' ' & (Date(ReloadTime(), 'DD/MM/YYYY') - 1) & ' ' & [end hour field],

if([shift field] = 2, (Date(ReloadTime(), 'DD/MM/YYYY') -1) & ' ' & [start hour field] & ' ' & (Date(ReloadTime(), 'DD/MM/YYYY') -1) & ' ' & [end hour field],

(Date(ReloadTime(), 'DD/MM/YYYY') -1) & ' ' & [start hour field] & ' ' & Date(ReloadTime(), 'DD/MM/YYYY') & ' ' & [end hour field])

Re: Shift Allocation Based on Reload time

anuradhaa — Fri, 06 Nov 2015 11:00:46 GMT

Can you please share a sample .