topic Re: display data on status basis in QlikView

display data on status basis

sk88024 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: display data on status basis

jonathandienst — Mon, 02 Dec 2019 11:51:04 GMT

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

Re: display data on status basis

Brett_Bleess — Wed, 11 Dec 2019 13:26:45 GMT

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