Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add seconds

Hi there

I have a problem in using time function in qlikview; assume that i have a variable that keeps Num of  now time in itself.I need to add 1 second to this number and again convert it to time format.which number can add one second to the number?

1 Solution

Accepted Solutions
sunny_talwar

Or you can add like this:

Time(FieldName + MakeTime(0, 0, 1))

View solution in original post

3 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Well,

given that under the hood QlikView stores each date as a floating point number, and there are 86400 seconds in a day

just add 1/86400 to your time

Marcus

sunny_talwar

Or you can add like this:

Time(FieldName + MakeTime(0, 0, 1))

Not applicable
Author

Tnx a lot.

works properly