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

    David Weiser

      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