topic Re: Need to pick 3pm records only in QlikView

Need to pick 3pm records only

Anonymous — Wed, 15 Nov 2017 20:10:43 GMT

I have "timestamp" data and I need to 1)pick only 3 pm and 4 pm between data.

2)only 3 pm data .when I reload.

below attachment have data

petter — Sun, 19 Nov 2017 11:53:33 GMT

You can try this:

LOAD
*
FROM <........>
WHERE
  Time(import_date) >=  '15:00' AND Time(import_date) < '16:00';

Replace <.......> with your Excel file specification....

its_anandrjs — Mon, 20 Nov 2017 12:39:16 GMT

Try this way also

Load

Complaint_no,

import_date,

parcol

From Source

Where Right(import_date,5) = '15:00';

Anonymous — Mon, 18 Dec 2017 11:06:00 GMT

thanks for reply me

Anonymous — Mon, 18 Dec 2017 11:06:43 GMT

thank you for reply me