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..

      Years

      2013
      2014
      2015

      2016

      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