Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

Left Join Freezing up

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Left Join Freezing up

You need to load an unique ID to join on

Left Join (Order)

Load

ID

...

Resident Order;

View solution in original post

7 Replies
Partner
Partner

Re: Left Join Freezing up

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

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

Partner
Partner

Re: Left Join Freezing up

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

manoranjan_d
Contributor II

Re: Left Join Freezing up

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;

manoranjan_d
Contributor II

Re: Left Join Freezing up

pls share the qvw file to us

Partner
Partner

Re: Left Join Freezing up

You need to load an unique ID to join on

Left Join (Order)

Load

ID

...

Resident Order;

View solution in original post

Partner
Partner

Re: Left Join Freezing up

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

rajivmeher
Contributor

Re: Left Join Freezing up

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.