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

      Hi,

       

      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:

       

      Jul-14
      Aug-14
      Sep-14
      Oct-14

       

      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.