Selecting data by time range

[#1]

Hi Qlikview Community

I have a time field in the following format (08:00:00 AM).

I only want to select data that is between the 04:30:00 AM to 11:30:00 PM which makes the up the plant production time.

I hope that you can assist.

[robert_mika]

Try

LOAD time

FROM

(ooxml, embedded labels, table is Sheet5)

where time>'04:30:00 AM ' and time <'11:30:00 PM'

[sushil353]

Hi,

Try : Where time > Time#('04:30:00 AM','HH:MM:SS TT') and time <  Time#('04:30:00 AM','HH:MM:SS TT')

HTH

Sushil