Time thing

[#1]

Hi there,

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?

Thanks in advance!

[hic · Accepted solution]

If it is a string '1235', then the following should do the trick:

     Time(Time#(Field, 'hhmm'), 'hh:mm')

HIC

[#3]

That worked a treat, thanks!