Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tan_chungkam
New Contributor III

Create 2 columns in scripting

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.

Scripting.PNG

Scripting.PNG

2. Separate 2 scripting.

Scripting for OrderType:

Scripting.PNG

Outcome:

Scripting.PNG

Scripting for column OriginalDeliveryWeek:

sc.PNG

Outcome:

Scripting.PNG

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

New to Qlik SenseQlikView Forums & ResourcesQlik Sense ForumsQlikView Creating AnalyticsNew to QlikView

4 Replies
ChennaiahNallani
Contributor III

Re: Create 2 columns in scripting

can you attache sample app

tan_chungkam
New Contributor III

Re: Create 2 columns in scripting

what do u mean sample app?

Is it the excel file?

ChennaiahNallani
Contributor III

Re: Create 2 columns in scripting

what do u mean sample app?

Yeah

tan_chungkam
New Contributor III

Re: Create 2 columns in scripting

Please find attached of the excel files.

Community Browser