Discussion board where members can get started with QlikView.
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.
Go to Solution.
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.
View solution in original post
Thz a lot it solve problem, and you script is easy to read and logical.thz!