topic Trouble getting time range onto slider in QlikView

Trouble getting time range onto slider

hopkinsc — Fri, 03 Sep 2010 16:10:49 GMT

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?

Trouble getting time range onto slider

Oleg_Troyansky — Fri, 03 Sep 2010 18:27:29 GMT

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

Trouble getting time range onto slider

hopkinsc — Sun, 05 Sep 2010 10:44:26 GMT

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?

Trouble getting time range onto slider

Oleg_Troyansky — Sun, 05 Sep 2010 17:07:16 GMT

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