topic Re: Selecting data by time range in QlikView

Selecting data by time range

Thu, 11 Jun 2015 08:44:58 GMT

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 — Thu, 11 Jun 2015 10:07:26 GMT

Try

LOAD time

FROM

(ooxml, embedded labels, table is Sheet5)

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

sushil353 — Thu, 11 Jun 2015 10:11:48 GMT

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