8 Replies Latest reply: Dec 6, 2016 9:50 PM by Guido Caffa RSS

    Compare year vs last year sales

    Guido Caffa

      In Qlik Sense..

      i want to compare the sales of a specific year (selected) with the year before. For example, if i selected 2015 de comparison will be 2015 vs 2014..




      VendorsYear selectedYear BeforYear1 - Year2

      Vendor 1

      Vendor 2

      Vendor 3


      The data is from a db in sql server... year colum name in the db is "feccbt", and the sales colum name is "imptotcbt". To show the total sales i do SUM(imptotcbt).


      I can't make that comparison.. Please help me, sorry for my poor english