2 Replies Latest reply: May 25, 2015 11:54 PM by Luke Teo RSS

    Have month and year as my dimension in a table and I want to create a measure that calculates the previous year sales

    Luke Teo



      As I'm new to Qlik Sense, can I please get some help on the following issue in Qlik Sense:


      I created a table that has a single column dimension such as:




      I then want to create a measure that calculate the sales of the previous year (which I do have in my loaded data) corresponding to the dimension so that it looks like this:


      Jul-14Sales of Jul-13
      Aug-14Sales of Aug-13
      Sep-14Sales of Sep-13
      Oct-14Sales of Oct-13


      Thanks for reading and helping out. Cheers.