Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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 II
Specialist II

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

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
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 II
Specialist II

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