Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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?
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?
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.
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 🙂