
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
time(time( '06:00:00' )+(time( '00:00:57' ) *2)
Maybe add the extra bracket

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
