Create From Time-To Time Fields

[rodrigue_saade]

Hi,

I need to create two fields that help me filter time. Fields are 'From Time'  and 'To Time'.

For example: i need to know the transactions that happened in certain date, from 09:00:00 am to 10:30:00 am.

How can i do this?

[MK_QSL]

Your question is too general and can't be answered with accurate point. We need some more information about what type of transaction format is and how you want to create two different Time?

[prieper]

Have you thought about using a slider already?

Peter

[Anonymous]

You may well need the IntervalMatch function.  The blog post mentioned is for date intervals but exactly the same can be done for time intervals, which I have done a fair few times successfully.

[#5]

In a Generic Sense,

You can Use the Range() Operator here....

[rodrigue_saade]

The point is that i need to filter all the app data, by selecting the from time - to time.

I think the slider is the only option, since the user may select time in hours, minutes and seconds.

Ex: 09:14:23

I tried the slider, but how to set the min and max value, so that the min value would be 00:00:00 and the max value 23:59:59?

[qlikmsg4u]

Hi Rodrigue,

Please find the attached app, is this what you are looking for?

[jonathandienst · Accepted solution]

Are you aware that QV times are actually in units of day, so 00:00:00 is a time value of 0, and 23:59:59 is a little less than 1 (0.99988..)?

So if your times a proper QV time values, set the minimum to 0 and the maximum to 1 and the set the slider to a number format of time.