Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be do something like this:
Interval(Round(expression, (1/(24*60*60))))
Check the help page of the function Round
Best regards,
D.A. MB
can you please help with expression
Check this post:
I'll try to figure something out
May be do something like this:
Interval(Round(expression, (1/(24*60*60))))
Thank you so much sunny