topic Re: Create From Time-To Time Fields in QlikView

Create From Time-To Time Fields

rodrigue_saade — Tue, 14 Jul 2015 08:27:59 GMT

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?

Re: Create From Time-To Time Fields

MK_QSL — Tue, 14 Jul 2015 08:32:42 GMT

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?

Re: Create From Time-To Time Fields

prieper — Tue, 14 Jul 2015 08:34:11 GMT

Have you thought about using a slider already?

Peter

Re: Create From Time-To Time Fields

Anonymous — Tue, 14 Jul 2015 08:36:19 GMT

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.

Re: Create From Time-To Time Fields

Tue, 14 Jul 2015 08:40:28 GMT

In a Generic Sense,

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

Re: Create From Time-To Time Fields

rodrigue_saade — Tue, 14 Jul 2015 08:47:13 GMT

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?

Re: Create From Time-To Time Fields

qlikmsg4u — Tue, 14 Jul 2015 09:13:54 GMT

Hi Rodrigue,

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

Re: Create From Time-To Time Fields

jonathandienst — Tue, 14 Jul 2015 09:18:46 GMT

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.