Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
as per your other thread:
If(Hour([Order Date])>=17 OR Hour([Order Date])<=8, 'PM', 'AM') as Night and Day
yes it is possible with Interval Match function with Qlikview , you can post sample data so that we can take it forward.
Vikas
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
as per your other thread:
If(Hour([Order Date])>=17 OR Hour([Order Date])<=8, 'PM', 'AM') as Night and Day
Hiya
thanks again your a star !!
Kind Regards