Based on one of them status to calculate other status

[beginnertom]

Hi everyone,

I have a dataset as below:

i would like to based on each serial no production status to calculate Model A status,

For example, For model A, since 4 of them is under run/ done status, i want to create a new field(model status) to claims Model A is 'paritally run'

if any status of model its serial no under run/done status, model status = 'partial run', 

if all status of model its serial no under stop status, model status = 'stop',

if all of model its serial no under done status, model status = 'done'

So  the output of model A and B model status are ' partial run and 'stop' respectively.

Based on model A and B model status, product line was calculated as 'partial run'

Is it possible to using qlikview to achieve this?Thz if anyone can give me an idea to tackle this problem.

Product Line	Model	Serial No	Status
Line A	Phone A	1	Run
Line A	Phone A	2	Done
Line A	Phone A	3	Done
Line A	Phone A	4	Run
Line A	Phone A	5	Run
Line A	Phone A	6	Stop
Line A	Phone B	7	Stop
Line A	Phone B	8	Stop
Line A	Phone B	9	Stop
Line A	Phone B	10	Stop
Line A	Phone B	11	Stop
Line A	Phone B	12	Stop

[Sergey_Shuklin · Accepted solution]

Hello!

You can solve this task with script improvement:

Where "base_table" is your original table from xlsx.

You need to do double join with concatenation result check groupped by Model field at first step and Product Line field at second step.

Example file is attached below.

[beginnertom]

Thanks,I will try it.

[beginnertom]

Thz a lot it solve problem, and you script is easy to read and logical.thz!