How to set exact time

[Anonymous]

Hello Qlikers,

this is my first question here...I haven't found solution so far...

I have column SEQ...sequnce from 1 to....5000. Need to create new column BuildTime, which will start From Today 6 a.m. and then each seqence will be postponed by 57 seconds.

Means:

Seq l  Build time

1     l  Today 6:00:00 am

2     l  Today 6:00:57 am

3     l  Today 6:01:54 am...

and so on...

Much appreciated any help---

Thanks.

[ValeriyaBartosh]

Hello,

mb try to use autogenerate () function

time(time( '06:00:00' )+time( '00:00:57' ) *1)

time(time( '06:00:00' )+time( '00:00:57' ) *2)

time(time( '06:00:00' )+time( '00:00:57' ) *3)

[vvvvvvizard]

time(time( '06:00:00' )+(time( '00:00:57' ) *2)

Maybe add the extra bracket

[Anonymous · Accepted solution]

Hi,

I figured it out like this:

Timestamp(If(Seq=1,'$(vToday)'+0.25,('$(vToday)'+0.25)+0.000666666666*(Sekvence-1))) as BuildTime

Thank you anyway for responses.