7 Replies Latest reply: Apr 21, 2015 11:04 AM by Darri Hilmarsson RSS

    How to see Revenue exactly one year back in Expression?

    Darri Hilmarsson

      Hi, QlikView community

       

      I have one issue I wanted to solve.

      Here below I have the data. Just a plain sales data.

      I am doing an analysis for the SalesRep in my company.

      But I got one request from a Sales Rep that I do not know how to solve.

      They want to know what their Sum(Revenue) is from this day a year ago until today (one year back).

      So I explain this request better. The SalesRep want to know when they open qlikview e.g. on the date 16. april 2015 they can see the Sum(Revenue) from 16. april 2014 until 16. april 2015. And when they open Qlikview next day (17. april 2015) they can see the Sum(Revenue) from 17. april 2014 until 17. april 2015

      Any have any ideas?

       

       

        

      OrderDateSalesRepItemRevenue
      23.1.2014KivellBinder999,5
      9.2.2014JardinePencil179,64
      26.2.2014GillPen539,73
      15.3.2014SorvinoPencil167,44
      1.4.2014JonesBinder299,4
      18.4.2014AndrewsPencil149,25