topic Define Shifts in App Development

Define Shifts

joeybird — Wed, 07 Oct 2015 13:47:51 GMT

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 — Thu, 08 Oct 2015 05:06:59 GMT

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

Vikas

joeybird — Thu, 08 Oct 2015 09:16:24 GMT

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

Thu, 08 Oct 2015 11:08:45 GMT

as per your other thread:

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

joeybird — Thu, 08 Oct 2015 13:15:29 GMT

Hiya

thanks again your a star !!

Kind Regards