topic Re: String to hh:mm in QlikView

String to hh:mm

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hello Friends,

We are storing time in our sql database as a string eg 0715. How can I change it to the correct format to read it as 07:15?

I tried the below but none formatted it right.

Time(Time#(TimeColumn,'hhmmTT'),'hh:mm')

Time(Time#(Mid(TimeColumn,1,4),'hh:mm'))

In addition, please also explain where I need to enter the expression or the formatting code since I am new to the QlikView.

Thank you.

Re: String to hh:mm

MK_QSL — Thu, 02 Apr 2015 21:09:40 GMT

Load

Time(Time#(TimeColumn,'hhmm'),'hh:mm') as TimeColumnNew;

SQL SELECT

Field1,

Field2,

TimeColumn,

Field4

From BlahBlah;

Re: String to hh:mm

Anonymous — Thu, 02 Apr 2015 23:49:53 GMT

It worked. I wasn't including the alias and didn't do proper selection in Load and Select.

I get the structure now. Thank you.

Re: String to hh:mm

Anonymous — Fri, 03 Apr 2015 00:19:04 GMT

This formatted time looks fine when I have CustomerID in a separate List Box and formatted time field in a separate List Box. However, when I try to see CustomerID and this formatted time field together in a Table Box, all the times get displayed as 00:00. Can you please help so that all the CustomerID displays all the correct times in Table Box instead of 00:00?