Qlik Sense Development issue

[kiansin]

Hi, I have a issue in Qlik Development. Kindly see the attached picture as below:

In this table , for this Main Order "2302588" has 6 sub orders no, and there are 2 type of "Order Type" which is 11 & 14.

My objective is always follow the Main Order "2302588" 's Order Type.

In this case , "Main Order" & "Sales Order No." 2302588's Order Type is "11" , so I want the rest Sales Order follow its value.

So the final output will be the field "Final Main OC Type" become "11" for this Main Order "2302588".

Is there any function or method can suggest or provide me to fulfill my objective ? 

Thanks in advance !!

[Or]

Load * From YourTable;

Join

Load [Main Order], Type as [Actual Main Order Type]

From YourTable

Where [Main Order] = [Sales Order No.];

[kiansin]

Hi Or,

Could you explain about your script please ?

[kiansin]

Hi Or ,

do you know how to fix it ?