3 Replies Latest reply: May 23, 2016 11:36 PM by Sunny Talwar RSS

    Year Over Year Change -- Qlik Sense

    David Weiser

      I am new to qlik sense.  I working with a table with the following column headers... Name, Year, Attendance. The years consist of 2011, 2014 and 2015... Attendance is a flag Y or N.  I am looking to find the change in attendance from 2011 to 2014 and from 2014 to 2015. If 50 more people attended in 2014 then 2011 then I want it to show as a positive otherwise if it was 50 less people then it should show as a negative.

       

      I am using the current expression, but it does not seem to be working.

      (sum(If(Year='2011' and Attendance='Y',1,0))) - (sum(If(Year='2014' and Attendance='Y',1,0)))

       

      It displays one positive bar graph for 2011 and a negative bar graph for 2014.  I only want to see one bar either positive or negative.

       

      Thanks