Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to display the task which has never been Rejected before and went to successful directly. (Successful directly can include the initial task status as CA and okay but not rejected).
Below is the sample data. Appreciate your help on this. Thank you
TASK | TASK STATUS | DATE |
B1 | Successful | 22/11/2019 |
A1 | Successful | 21/11/2019 |
A1 | CA | 21/11/2019 |
A2 | Rejected | 26/11/2019 |
A2 | Rejected | 26/11/2019 |
A2 | Successful | 26/11/2019 |
A3 | Successful | 25/11/2019 |
B2 | Okay | 27/11/2019 |
B2 | Successful | 27/11/2019 |
B3 | Rejected | 27/11/2019 |
B3 | Okay | 27/11/2019 |
Output Tasks which were never rejected before | ||
B1 | ||
A1 | ||
A3 | ||
B2 | ||
To get a list of tasks (for a list box or a dimension):
Aggr(Only({<TASk = E({<[TASK STATUS] = {'Rejected'}>} TASK)>} TASK), TASK)
You can also display this as an expression by concatenating (in a text box, for example),
Concat(Distinct Aggr(Only({<TASk = E({<[TASK STATUS] = {'Rejected'}>} TASK)>} TASK), TASK), ', ')
or adding the chart/table dimensions to the Aggr():
Aggr(Only({<TASk = E({<[TASK STATUS] = {'Rejected'}>} TASK)>} TASK), TASK, <ChartDim1>, <ChartDim2>,...)
To get a list of tasks (for a list box or a dimension):
Aggr(Only({<TASk = E({<[TASK STATUS] = {'Rejected'}>} TASK)>} TASK), TASK)
You can also display this as an expression by concatenating (in a text box, for example),
Concat(Distinct Aggr(Only({<TASk = E({<[TASK STATUS] = {'Rejected'}>} TASK)>} TASK), TASK), ', ')
or adding the chart/table dimensions to the Aggr():
Aggr(Only({<TASk = E({<[TASK STATUS] = {'Rejected'}>} TASK)>} TASK), TASK, <ChartDim1>, <ChartDim2>,...)
Did the response help you with your problem? If so, do not forget to return to your post and use the Accept as Solution button on the poster's post to give them credit for the assistance which also confirms to other Community Members that it did work for you. If you are still working upon things, leave an update on what you still need.
One very useful area for new folks is the following:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Lots of how-to related posts in that area that should prove very helpful to you going forward.
Regards,
Brett