Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

time format while exporting

Hi Experts,

i have an expression which calculates interval(expression) with the format hh:mm:ss

for example my value of that expression is 00:01:51

when i export to excel this value gets changed to 00:01:52

this is because of the millisecond in excel rounding to the next second (00:01:51.7 changed to 00:01:52)

is it possible to do this rounding in qlikview expression?

if so, can anyone please help me with the expression?

1 Solution

Accepted Solutions
sunny_talwar

May be do something like this:

Interval(Round(expression, (1/(24*60*60))))

View solution in original post

7 Replies
Anonymous
Not applicable
Author

Hi,

Have a look:

Rounding Errors

Hope it helps

miguelbraga
Partner - Specialist III
Partner - Specialist III

Not applicable
Author

can you please help with expression

miguelbraga
Partner - Specialist III
Partner - Specialist III

Check this post:

Rounding time

miguelbraga
Partner - Specialist III
Partner - Specialist III

I'll try to figure something out

sunny_talwar

May be do something like this:

Interval(Round(expression, (1/(24*60*60))))

Not applicable
Author

Thank you so much sunny