Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

davidbe1
Contributor

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

Tags (1)
1 Solution

Accepted Solutions

Re: Date Time

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?

11 Replies

Re: Date Time

May be use Hour() function

Hour(EntryDateTime) as Hour

davidbe1
Contributor

Re: Date Time

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

E.g 10:25

sureshqv
Esteemed Contributor III

Re: Date Time

try

=Hour(Datefield)

Re: Date Time

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?

davidbe1
Contributor

Re: Date Time

Amazing thank you so much !!!

davidbe1
Contributor

Re: Date Time

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

Capture3.JPG

Re: Date Time

Hour to Hour free selection?

davidbe1
Contributor

Re: Date Time

Yes

Re: Date Time

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

Community Browser