Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try
LOAD time
FROM
(ooxml, embedded labels, table is Sheet5)
where time>'04:30:00 AM ' and time <'11:30:00 PM'
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