Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
davidbe1
Creator
Creator

Date Time

Hey Community,

I have field EntryDateTime (15/03/2016 10:40:45)

How can i use only the hour ?

My client wants to chose From - To Hour in his selection

I add the app, the problem is when i choose from the var date From date - To date

And press apply i dont get all the selection

1 Solution

Accepted Solutions
sunny_talwar

To get minute you can try this:

Time(Frac(EntryDateTime, 'hh:mm')

Can you check if the selection is now working in your attached sample?

View solution in original post

11 Replies
sunny_talwar

May be use Hour() function

Hour(EntryDateTime) as Hour

davidbe1
Creator
Creator
Author

Thx @Sunny TBut i get only round hour if i need also the min ?

E.g 10:25

Chanty4u
Champion III
Champion III

try

=Hour(Datefield)

sunny_talwar

To get minute you can try this:

Time(Frac(EntryDateTime, 'hh:mm')

Can you check if the selection is now working in your attached sample?

View solution in original post

davidbe1
Creator
Creator
Author

Amazing thank you so much !!!

davidbe1
Creator
Creator
Author

How can i make From Hour To Hour Free selection to the user, That will impact the EntryDateTime ?

Capture3.JPG

sunny_talwar

Hour to Hour free selection?

davidbe1
Creator
Creator
Author

Yes

sunny_talwar

I don't understand what you mean by Hour to Hour selection. Can you may be elaborate?