Create 2 columns in scripting

[tan_chungkam]

I had created 2 column by scripting.

It works when I put in 1 column at a times.

When I put 2 columns scripting together it does not work.

Please find below table pic and my scripting. Thanks.

1. 2 scripting column together.

2. Separate 2 scripting.

Scripting for OrderType:

Outcome:

Scripting for column OriginalDeliveryWeek:

Outcome:

Is there any idea to put that 2 together without any duplicate of the order. Thanks.

New to Qlik Sense‌QlikView Forums & Resources‌Qlik Sense Forums‌QlikView Creating Analytics‌New to QlikView‌

[ChennaiahNallani]

can you attache sample app

[tan_chungkam]

what do u mean sample app?

Is it the excel file?

[ChennaiahNallani]

what do u mean sample app?

Yeah

[tan_chungkam]

Please find attached of the excel files.