Trouble getting time range onto slider

[hopkinsc]

Hi, i am trying to get a time range on a multi value slider.

I am loading in times in the format of 0 - 235959 (0 being 00:00:00 and 235959 being 23:59:59) they are being displayed correctly on the slider scale, but when you move the thumb tack the small pop up box appears telling you the exact value but it is not showing it in the time format.

In the picture below it shows the time range being 6:72:00 - 15:65:00, obviously there are not 72 or 65 mins in an hour. Does anyone know how to correct this please?

[Oleg_Troyansky]

I'd recommend converting your numbers into a proper Timestamp field (using function MakeTime) - then QlikView will take care of proper formatting...

[hopkinsc]

Hi Oleg, thanks for your reply...

What to you mean using function MAKE TIME? Where is that function? and what data do i need to convert, the data coming into qlikview or is the coversion done in qlikview itself?

[Oleg_Troyansky]

Function MakeTime (no spaces, one word) is one of many Date & Time functions in QlikView - search the Help Section for either MakeTime, or "Date Functions". and you should find the article.

You can use it in your load script to transform the incoming data from your representation of time into a field of the Timestamp type - then it's easier to format it and make necessary calculations (like calculate time intervals etc...)