Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

difference addition of hours

Hello!

Faced with such a problem, the function MakeTime() is not correctly execute.

In cycle FOR by addition hour "vTempDate+ MakeTime(1)", QlikView lost one second on step 596 (look in attach),


But, "vTempDate+ 1/24" execute correct.

Why is that???

3 Replies
hic
Former Employee
Former Employee

For some reason the MakeTime(1) returns a value which is slightly smaller than 1/24. We will look into that - it looks like a bug.

     MakeTime(1) = 0,04166666665697

     1/24               = 0,04166666666667

But the difference is less than one microsecond, so it will only be noticeable in a situation where you accumulate rounding errors, which is something you should avoid by coding smart. See more about rounding errors here: http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors

HIC

Not applicable
Author

If this looks like bug - what should i do?

where it is necessary to write about that?

Thank You for the link

hic
Former Employee
Former Employee

You could report this to QlikTech Support. I will also report this internally (within QlikTech).

HIC