11 Replies Latest reply: May 27, 2016 11:58 AM by Sunny Talwar RSS

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

      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".