Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sayalip
Contributor II
Contributor II

aggr function

HI Everyone,

it would be great if you suggest on below-

i have below data

Emp iddateflag
101-01-2020Y
201-01-2020N
301-01-2020Y
401-01-2020Y
501-01-2020Y
115-01-2020N
216-01-2020Y
320-01-2020N

 

flag value says yes or no for employee who is coming for event. (if employee is coming for event then flag yes else no)

date is updated entry for employee if employee changes mind for attending event.

i want final list of employee who are coming for event.

 

 

 

 

1 Solution

Accepted Solutions
sunny_talwar

Try this

=-Sum(Aggr(FirstSortedValue(flag, -date) = 'Y', [Emp id]))

 

View solution in original post

2 Replies
sunny_talwar

Try this

=-Sum(Aggr(FirstSortedValue(flag, -date) = 'Y', [Emp id]))

 

sayalip
Contributor II
Contributor II
Author

thank you so much it works.