Define Shifts

[joeybird]

Hiya

how would it be possible to create a filter pane, to show Day Shift and Evening Shift selection?

however I need to define the time bracket for the start and finish of each shift

is this possible?

please help

[vikasmahajan]

yes it is possible with Interval Match function with Qlikview , you can post sample data so that we can take it forward.

Vikas

[joeybird]

Hiya

my Order Date field looks something like this:

01/01/2015 09:00:00

as you can see it contains both date and time in same field.

I wish to use something like this

If((Time(Frac([Order Date]))>=Time('17:00:00') AND Time(Frac([OrderDate]))<=Time('08:00:00')), 'Night', 'Day')

but I cant seem to get it to work. filter just shows 'Day' and it does not seem to link to anything.

Please help

[#4 · Accepted solution]

as per your other thread:

If(Hour([Order Date])>=17 OR Hour([Order Date])<=8, 'PM', 'AM') as Night and Day

[joeybird]

Hiya

thanks again your a star !!

Kind Regards