Help with a Set expression

[#1]

Hi

Can someone help me to get a set expression right.

I want to

Count({<Avgorsak ={9} >} Distinct PersonID)      but only for those that dont have a HireDate that are larger than the EndDate

It´s a stright tabel that shows how many people that have ended ther hirings and don´t have come back later.

It´s the ones that have been rehired I want to remove.

[Gysbert_Wassenaar]

Perhaps like this:

Count({<Avgorsak ={9},PersonID={"=aggr(max(HireDate),PersonID)<=EndDate"} >} Distinct PersonID)

[#3]

I think you are on the right way, but now I fund that people that are still hired are set to 9999-12-31 as enddate. In your above expression, how can I exclude that date?

[Gysbert_Wassenaar · Accepted solution]

Something like:

Count({<EndDate -= {'9999-12-31'}, Avgorsak ={9},PersonID={"=aggr(max(HireDate),PersonID)<=EndDate"} >} Distinct PersonID)

You may have to use the date# function to make a date of 9999-12-13. The expression editor doesn't understand -= but it's the correct syntax.