Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

beginnertom
New Contributor III

Based on one of them status to calculate other status

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 LineModelSerial NoStatus
Line APhone A1Run
Line APhone A2Done
Line APhone A3Done
Line APhone A4Run
Line APhone A5Run
Line APhone A6Stop
Line APhone B7Stop
Line APhone B8Stop
Line APhone B9Stop
Line APhone B10Stop
Line APhone B11Stop
Line APhone B12Stop
1 Solution

Accepted Solutions
Sergey_Shuklin
Valued Contributor

Re: Based on one of them status to calculate other status

Hello!

You can solve this task with script improvement:

model_status.png

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.

View solution in original post

3 Replies
Sergey_Shuklin
Valued Contributor

Re: Based on one of them status to calculate other status

Hello!

You can solve this task with script improvement:

model_status.png

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.

View solution in original post

beginnertom
New Contributor III

Re: Based on one of them status to calculate other status

Thanks,I will try it.
beginnertom
New Contributor III

Re: Based on one of them status to calculate other status

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