topic Re: Time thing in QlikView https://community.qlik.com/t5/QlikView/Time-thing/m-p/564520#M1111522 <HTML><HEAD></HEAD><BODY><P>That worked a treat, thanks!</P></BODY></HTML> Tue, 25 Feb 2014 10:40:39 GMT 2014-02-25T10:40:39Z Time thing https://community.qlik.com/t5/QlikView/Time-thing/m-p/564518#M1111520 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I've quite new to Qlikview, but I'm running into an issue I'm not quite sure how to tackle. In my DB is a field with time registrations. It is however stored in a pure number format, so 12:35 would be 1235 in the DB. I'm trying to get this converted to a time format that QV understands as time, but I'm having no luck with it so far. I have tried a number of different timestamp#() variants, but I'm still not managing to get the format right. Can someone help me with this?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 25 Feb 2014 10:33:05 GMT https://community.qlik.com/t5/QlikView/Time-thing/m-p/564518#M1111520 2014-02-25T10:33:05Z Re: Time thing https://community.qlik.com/t5/QlikView/Time-thing/m-p/564519#M1111521 <HTML><HEAD></HEAD><BODY><P>If it is a string '1235', then the following should do the trick:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Time(Time#(Field, 'hhmm'), 'hh:mm')</P><P></P><P>HIC</P></BODY></HTML> Tue, 25 Feb 2014 10:38:02 GMT https://community.qlik.com/t5/QlikView/Time-thing/m-p/564519#M1111521 hic 2014-02-25T10:38:02Z Re: Time thing https://community.qlik.com/t5/QlikView/Time-thing/m-p/564520#M1111522 <HTML><HEAD></HEAD><BODY><P>That worked a treat, thanks!</P></BODY></HTML> Tue, 25 Feb 2014 10:40:39 GMT https://community.qlik.com/t5/QlikView/Time-thing/m-p/564520#M1111522 2014-02-25T10:40:39Z