3 Replies Latest reply: Sep 3, 2018 4:43 AM by Michal Solonka

# How to set exact time

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.

• ###### Re: How to set exact time

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)

• ###### Re: How to set exact time

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

• ###### Re: How to set exact time

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.