Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Transaction Time Range

Hi, I have managed to get a Transaction Date range working successfully on my application using calendars.

I would now like to set up the same but using time. I am just asking for any ideas on what would be the best to use to present the end user the option to enter an exact time range (HH:MM) It obviously needs to be User friendly and to look good.

The only thing i can find is an input box which to me isn't either of the above.

error loading image

Any help and if possible some examples would be great.

I know how to get the time range to work, so all i'm looking for is display options.

Thanks for your time.

4 Replies
johnw
Champion III
Champion III

How about a multi value slider on your time field, long enough to show the hours, and to be able to select down to minutes?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

The slider bar is ok, but to fit in 24hrs it gets quite big. I was hoping for something like an input box but a user friendly one, where the user can just tap in 1300 for example and the box would automatically insert the colon bewteen 13 and 00 or maybe a drop down box, hour drop down and minute drop down. is something like that available on Qlikview?

johnw
Champion III
Champion III

Oh, sure, I just thought you were trying to get away from using an input box. Go to the Number tab, select "Time", and enter the format you want in the format pattern, probably h:mm in this case. The user can then enter the times, though they will need to enter the colon themselves. Or you can have the input box for both Hour and Minute with drop downs. For Hour, on the Constraints tab, under Value List select "Predefined Values in Drop-down", then under Predefined Values, checkmark Number Series and enter from 0 to 23 step 1. Do the same sort of thing for Minute. To convert hours and minutes to an actual time, though, you'll need to use an expression like time((Hour+Minute/60)/24), since time of day actually varies between 0 and 1 internally. See attached.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Thanks John,

The input box works, it's not as 'pretty' as i wanted it really but it will do the job 🙂

Is there no way at all that the colon would be put in automatically if i were to use a standard input box? Is there not an expression i could write to put it in after the 2nd digit?

Thanks for your time 🙂