Discussion Board for collaboration related to QlikView App Development.
Can somebody please help me on this?
I have a field which is ETA time but the value provided is not in hh:mm so I converted it hh:mm using the following:-
then I wanted to assign a delivery window by using the following inline
The results were correct except for 13:00 which it was not able to assign a delivery window
When I changed the inline to the following:-
it was able to assign for 13:00 but 12:00 was assigned with 2 delivery windows
May I know whether it is because of the conversion of the ETA to hh:mm that is causing the issue as when I exported the values to Excel it looks weird
It's most likely a rounding error that is causing your issue.
The numeric representation of ETA 13:00 is larger than your F2 12:59 and smaller than your F1 13:00.
Try adding seconds to your F2 time.
Load * inline [
F1, F2, DeliveryWindow
12:00:00, 12:59:59, 12pm to 3pm
13:00:00, 13:59:59 , 13pm to 4pm];