Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

Define Shifts

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


1 Solution

Accepted Solutions
Not applicable

Re: Define Shifts

as per your other thread:



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

4 Replies
vikasmahajan
Honored Contributor III

Re: Define Shifts

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

Vikas

joeybird
Contributor II

Re: Define Shifts

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

Not applicable

Re: Define Shifts

as per your other thread:



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

joeybird
Contributor II

Re: Define Shifts

Hiya

thanks again your a star !!

Kind Regards