topic Re: Smaller or equal too calculating with times in QlikView

Smaller or equal too calculating with times

Tue, 28 Jan 2014 11:53:34 GMT

Hi,

I'm trying to report how many trucks in my dataset arrived on time. All trucks that arrive within half an hour after their booked time (Delivery Due Time), or on time. To do this, I added the following line to my script:

If([Vehicle arrival Time]-[Delivery DueTime]<=(1/48), 1,0) as [On time]

If a truck is half an hour late (1/48 hour), it is still on time. That's why i put <= 1/48 in my script. However, when the truck arrives exactly half an hour later than their booked time, Qlikview still regards them as late (it gives them a "0" as value). Can anybody explain this/help me with this issue?

Thanks

Re: Smaller or equal too calculating with times

Clever_Anjos — Tue, 28 Jan 2014 12:01:08 GMT

Maybe some rounding problem, try rounding to nearest minute

If(round([Vehicle arrival Time]-[Delivery DueTime],1/(24*60))<=(1/48), 1,0) as [On time]

Re: Smaller or equal too calculating with times

nilesh_gangurde — Tue, 28 Jan 2014 12:01:20 GMT

Please attach sample qvw.

-Nilesh

Re: Smaller or equal too calculating with times

jonathandienst — Tue, 28 Jan 2014 12:09:09 GMT

I would try and take the floating point comparison out completely, like this

If(Round(([Vehicle arrival Time]-[Delivery DueTime]) * 48) <= 1, ...)

HTH

Jonathan

Re: Smaller or equal too calculating with times

jonathandienst — Tue, 28 Jan 2014 12:10:56 GMT

If(Round(([Vehicle arrival Time]-[Delivery DueTime]) * 24, 0.1) <= 0.5, ...)

Re: Smaller or equal too calculating with times

Tue, 28 Jan 2014 12:58:53 GMT

I tried the suggestions with the Round(..) formula, but it didn't work either. Eventually, I changed 1/48 to 31/1440. That solved the problem.

Thanks for your help

Best regards,

Niek