display data on status basis

[sk88024]

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

[jonathandienst · Accepted solution]

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>,...)

[Brett_Bleess]

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