topic Re: Inline in QlikView

Inline

jennytan — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Re: Inline

Vegar — Wed, 07 Oct 2020 08:10:35 GMT

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

Re: Inline

avinashelite — Wed, 07 Oct 2020 08:15:15 GMT

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

Re: Inline

jennytan — Wed, 07 Oct 2020 08:35:15 GMT

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]

Re: Inline

jennytan — Wed, 07 Oct 2020 08:51:33 GMT

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

Re: Inline

QFabian — Wed, 07 Oct 2020 19:45:00 GMT

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

see the atached image.