10 Replies Latest reply: Mar 29, 2017 11:16 AM by Michael Tarallo RSS

    In Qlik Sense how would you create measure to show ThisYear sales rev and LastYrsales rev

      I would like to show in a table the Regional sales for ThisYr(2014) and LastYr(2013). Plus a Variance  at the end



      Region Name2013 SALES2014 SALES


      The data is stored by transaction date in an Xls sheet, which I have been able to convert to via the Load script to Month, Quarter and Year.  In Qlik View it appears you are able to use variables to achieve this.  How would this problem be approached in Qlik sense.