Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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