8 Replies Latest reply: Feb 8, 2018 2:22 PM by Arnaldo Candia RSS

    How to obtain the sales of the previous year?

    Arnaldo Candia

      Hello, I am new to Qlik sense, and I want to compare the sales of the previous year with the current selected year.

       

      Example

       

                      2017      2016           difference

       

      sales           x1           x2                x1-x2

       

      The format of the dimension DATE is ddmmyyyy.

       

      I'm using sum ({$ <DATE.autoCalendar.Year = {$ (# = Only (DATE.autoCalendar.Year) -1)}>} Sales), but it does not work for me.

       

      Please help

      my date table is this and I want to be able to get the sales of the previous year selected. For example if I have selected 2017 then the sales of the previous year (2016 in this case) would be 2050.

      Sin título.jpeg