topic Re: Left Join Freezing up in QlikView

Left Join Freezing up

azmeerrehan — Wed, 12 Sep 2018 13:23:45 GMT

I am doing the below left Join

Left Join (Order)

Load

If([DATE A<=DATE B,'On Time',

If(DATE A>DATE B and

DATE A <= DATE C,'Late',

If(DATE A> DATE C,

'vERY LATE'))) as Order_STatus

Resident Order;

IT freezes up on this join and then gives me the script error. Any idea what am I doing wrong here

Re: Left Join Freezing up

Anonymous — Wed, 12 Sep 2018 13:28:45 GMT

in your first if there is a character [ without a closing one

I supoose you Need [DATA A] and all other too

Re: Left Join Freezing up

azmeerrehan — Wed, 12 Sep 2018 13:32:05 GMT

NO it is there . Its just a typo in the discussion. I am getting the "Execution Of the Script Failed" Error

Re: Left Join Freezing up

manoranjan_d — Wed, 12 Sep 2018 13:34:36 GMT

i think you have to use field name correctly its case sensitive

TRY1:

field DATE_A it should be defined without space

if its not case sensitive

TRY2:

If(Date(A,'MM-DD-YYYY')<= Date(C,'MM-DD-YYYY'),'On Time',

If(Date(A,'MM-DD-YYYY')> Date(B,'MM-DD-YYYY') and

Date(A,'MM-DD-YYYY')<= Date(C,'MM-DD-YYYY'),'Late',

Date(A,'MM-DD-YYYY')> Date(C,'MM-DD-YYYY'),'VERY LATE')) as Order_STatus

Resident Order;

Re: Left Join Freezing up

manoranjan_d — Wed, 12 Sep 2018 13:35:44 GMT

pls share the qvw file to us

Re: Left Join Freezing up

stigchel — Wed, 12 Sep 2018 13:36:25 GMT

You need to load an unique ID to join on

Left Join (Order)

Load

...

Resident Order;

Re: Left Join Freezing up

azmeerrehan — Wed, 12 Sep 2018 13:39:22 GMT

If I am doing the LImited load its fine, it eans that I dont have an issue in the script

Re: Left Join Freezing up

rajivmeher — Wed, 12 Sep 2018 13:48:04 GMT

Hi Rehan

Please use NUM for date and see if it gets better.

Left Join (Order)

Load

If([NUM(DATE A)<=NUM(DATE B),'On Time',

If(NUM(DATE A)>NUM(DATE B) and

NUM(DATE A) <= NUM(DATE C),'Late',

If(NUM(DATE A)> NUM(DATE C),

'vERY LATE'))) as Order_STatus

Resident Order;

Regards

Rajiv.