Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
rodrigue_saade
Partner - Creator
Partner - Creator

Create From Time-To Time Fields

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?

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

7 Replies
MK_QSL
MVP
MVP

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
Master II
Master II

Have you thought about using a slider already?

Peter

Anonymous
Not applicable

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.

Not applicable

In a Generic Sense,

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

rodrigue_saade
Partner - Creator
Partner - Creator
Author

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
Specialist
Specialist

Hi Rodrigue,

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein