This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I'm trying to round time to the closest hour using this expression:
but something strange happens, it's partially working:
you can see that the first row is wrong, the Hour (hh) field should be 04:00 PM, while the second row is ok.
What is the explanation for this behavior?
There seems to be some "rounding error" in the very small decimals. FRAC for 16:00 gives 0,66666666666424 and not expected 0,66666666666667. If you add a very small number this should fix it.
=time(floor(frac(STARTTIME + 0.000001),1.0/24.0),'hh:mm') gives 16:00.
Num (STARTTIME) gives 43531.666666667 whereas Frac (Num(STARTTIME)) or Num (Frac(STARTTIME)) gives 0.66666666666424 whereas you would expect 0.666666667.
View solution in original post
Thanks, @johanlindell !
I still don't understand why it works ok with ObjectID 10808 and not with 10807...
This is the data I have in Oracle DB:
so strange 🙂
but thanks again.