Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jennytan
Contributor II
Contributor II

Inline

Hi,

Can somebody please help me on this?

Thank you.

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:-

jennytan_0-1602055906686.png

then I wanted to assign a delivery window by using the following inline

jennytan_1-1602056000673.png

The results were correct except for 13:00 which it was not able to assign a delivery window

jennytan_2-1602056069853.png

 

When I changed the inline to the following:-

jennytan_3-1602056113793.png

 

it was able to assign for 13:00 but 12:00 was assigned with 2 delivery windows

jennytan_4-1602056159764.png

 

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

jennytan_5-1602056268210.png

 

 

 

 

 

 

 

 

 

 

1 Solution

Accepted Solutions
QFabian
Specialist III
Specialist III

hi, try converting the hours to numbers first, and then make the interval over the numbers and not over hours.

see the atached image.

QFabian

View solution in original post

5 Replies
Vegar
MVP
MVP

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];

 

avinashelite

Instead of image could you upload the same data ? that will save time to generate the data ?

jennytan
Contributor II
Contributor II
Author

Hi Vegar,



Thank you for your assistance.



I changed the inline as per suggested and there is no duplication for 12:00 but it is unable to assign for 13:00



[cid:image001.png@01D69CC7.D1423390]



[cid:image002.png@01D69CC7.D1423390]
jennytan
Contributor II
Contributor II
Author

This is the definition for the inline and the results of the data.

QFabian
Specialist III
Specialist III

hi, try converting the hours to numbers first, and then make the interval over the numbers and not over hours.

see the atached image.

QFabian