4 Replies Latest reply: Aug 19, 2010 4:53 AM by Chris Hopkins RSS

    Transaction Time Range

    Chris Hopkins

      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.

        • Transaction Time Range
          John Witherspoon

          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?

            • Transaction Time Range
              Chris Hopkins

              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?

                • Transaction Time Range
                  John Witherspoon

                  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.

                    • Transaction Time Range
                      Chris Hopkins

                      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 :)