topic Re: Difficulty formatting Time in QlikView

Difficulty formatting Time

Fri, 02 Oct 2015 11:29:05 GMT

I retrieve data from an SQL database where time is stored as an integer. After loading the time into Qlikview, is there a means by which I can format it so as to display as HH:MM. I tried changing the number format in properties section, but since the time is stored as an integer initially in the database, it does not work. Would anyone be able to help me on this.

eg: Integer 759 should be displayed as 7:59 aftre loading in QlikView

Re: Difficulty formatting Time

maxgro — Fri, 02 Oct 2015 11:59:52 GMT

maybe

Time#(num(yoursqlfield, '0000'), 'hhmm')

Re: Difficulty formatting Time

MK_QSL — Fri, 02 Oct 2015 12:04:03 GMT

=Time(TIme#(Num('759','0000'),'hhmm'),'hh:mm')

=Time(TIme#(Num(YourFieldName,'0000'),'hhmm'),'hh:mm')

Re: Difficulty formatting Time

Fri, 02 Oct 2015 12:35:21 GMT

I just copy pasted your 2nd line of code and it worked. I am glad. Thank You very much.

Re: Difficulty formatting Time

MK_QSL — Fri, 02 Oct 2015 21:44:08 GMT

Glad that my solution worked for you.

Better if you close the thread by selecting correct answer so that others having same issue can use it.