topic Qlik Sense Development issue in App Development

Qlik Sense Development issue

kiansin — Tue, 21 Mar 2023 08:38:40 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 !!

Or — Tue, 21 Mar 2023 10:36:43 GMT

Load * From YourTable;

Join

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

From YourTable

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

kiansin — Thu, 23 Mar 2023 02:35:45 GMT

Hi Or,

Could you explain about your script please ?

kiansin — Thu, 23 Mar 2023 07:51:50 GMT

Hi Or ,

do you know how to fix it ?