Discussion board where members can learn more about Qlik Sense App Development and Usage.
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?
Go to Solution.
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.
my Order Date field looks something like this:
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.
thanks again your a star !!