topic Re: Date Time in QlikView

Date Time

Anonymous — Wed, 30 Mar 2016 09:32:39 GMT

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

Re: Date Time

sunny_talwar — Wed, 30 Mar 2016 11:13:14 GMT

May be use Hour() function

Hour(EntryDateTime) as Hour

Re: Date Time

Anonymous — Wed, 30 Mar 2016 11:28:13 GMT

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

E.g 10:25

Re: Date Time

Chanty4u — Wed, 30 Mar 2016 11:37:54 GMT

try

=Hour(Datefield)

Re: Date Time

sunny_talwar — Wed, 30 Mar 2016 12:40:10 GMT

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?

Re: Date Time

Anonymous — Wed, 30 Mar 2016 12:42:23 GMT

Amazing thank you so much !!!

Re: Date Time

Anonymous — Wed, 30 Mar 2016 13:48:26 GMT

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

Re: Date Time

sunny_talwar — Wed, 30 Mar 2016 14:54:56 GMT

Hour to Hour free selection?

Re: Date Time

Anonymous — Thu, 31 Mar 2016 05:09:41 GMT

Yes

Re: Date Time

sunny_talwar — Thu, 31 Mar 2016 10:40:21 GMT

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

Re: Date Time

Anonymous — Thu, 31 Mar 2016 10:47:25 GMT

Yes sure,

my client wants to see report of his data but also to be able select by Range.

ex. From Data To Date

From Hour To Hour

From Price To Price

are you recommend me to do this whit var ?

Re: Date Time

sunny_talwar — Thu, 31 Mar 2016 12:15:00 GMT

Can you reattach the application with these two fields:

1) Date(Floor(DateField)) as New_DateField

2) Time(Frac(DateField)) as New_TimeField

Use the datefield which you want to use for filtering purposes.