Counting with more than one condition of a data group

[Anonymous]

Good afternoon, I am trying to create a table that allows me to count the number of students who are retired from a university, here is an  example of the information I have:

Year	ID	Name	Program	Status
200620	1000	Luis   Flechas	ENI	Graduate
200620	1000	Luis   Flechas	ADD	Retired
200620	1000	Luis   Flechas	COF	Normal

l

In this case the same student, for the same year, has different programs and a status for each program.

I need to count how many students were retired for one year, taking into account that if the student for that same year already has a Graduate or Normal status, he should not enter in the retired count, regardless of the program.

The student should be counted only 1 time in the cases where the status of each programa is retired. This means that is the student has 3 programas and in all of them he apears as Retired, he should count just one time.

I appreciate very much if you can help me.

regards,

[jwjackso]

I would try the e() function, https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-mod...

=Count({<ID=E({<Status={'Graduate','Normal'}>}),Status={'Retired'}>} Distinct ID)

[arvind_patil]

Hi Lizette,

Could you please tell us what is your desired output.

Thanks,

Arvind Patil

[Anonymous]

thank you guys, I used the following function

= Count ({$<ID= p({$<STATUS ={Retired}>}ID) - p({$<STATUS ={'Graduate','Normal'}>}ID)>} distinct ID)

it works perfect.