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
      Berkshire$100$200
      Bucks$50$150
      Bedfordshire$400$300

       

      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.

       

      Thanks