Qlik Sense - How do you compare current row to previous row in same column

[#1]

I want to track subjects that have been enrolled in concurrent years to create a cohort.  I have data for 2011, 2014, and 2015. 

I want to compare my current row (attendance) to previous row using a count if statement. This will become clearer when you view the attached spreadsheet.

My column headers are User Id, Year and Attendance.

I am trying to use the statement:

Count (If(Attendance='Y' and Above(Attendance) = 'Y',1,0))

I am getting a syntax error using "Above".

Thanks

David

[#2]

Thank you very much for getting back to me...  That seemed to work... Now I just have to understand the equation. I understand the If and Count portion... need to research the Aggr with the Year1, Year at the end of the function. Not sure how that works.

Again thank you very much for your help.

[sunny_talwar · Accepted solution]

No a problem

Read about Aggr() here:

http://www.analyticsvidhya.com/blog/2014/02/aggr/

http://www.learnallbi.com/aggr-function-in-qlikview/

Qlik Design Blog : AGGR... | Qlik Community‌

Pitfalls of the Aggr function

When should the Aggr() function NOT be used?