topic Re: time format while exporting in QlikView

time format while exporting

Wed, 25 Nov 2020 16:16:04 GMT

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?

Anonymous — Thu, 22 Sep 2016 09:50:38 GMT

Hi,

Have a look:

Hope it helps

miguelbraga — Thu, 22 Sep 2016 09:53:06 GMT

Check the help page of the function Round

Best regards,

D.A. MB

Thu, 22 Sep 2016 09:58:00 GMT

can you please help with expression

miguelbraga — Thu, 22 Sep 2016 10:04:58 GMT

Check this post:

miguelbraga — Thu, 22 Sep 2016 10:05:13 GMT

I'll try to figure something out

sunny_talwar — Thu, 22 Sep 2016 10:59:49 GMT

May be do something like this:

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

Thu, 22 Sep 2016 12:23:16 GMT

Thank you so much sunny