Qlik Sense Development issue

kiansin — Mon, 27 Mar 2023 08:53:11 GMT

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

topic Qlik Sense Development issue in App Development