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 !!