Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need to pick 3pm records only

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

IMG-20171116-WA0000.jpg

4 Replies
petter
Partner - Champion III
Partner - Champion III

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
Champion III
Champion III

Try this way also

Load

Complaint_no,

import_date,

parcol

From Source

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

Anonymous
Not applicable
Author

thanks for reply me

Anonymous
Not applicable
Author

thank you for reply me