2 Replies Latest reply: Sep 30, 2015 12:04 PM by jagan mohan rao appala RSS

    Chart that shows last 12 YearPeriod (last 12 months)

    Darri Hilmarsson

      Hi, QlikView

       

      I have data set that shows sales number and date when they happen.

      I want to make a chart what shows sales numbers for last 12 YearPeriod

       

      I will explain better. So today is 30.09.2015 which is YearPeriod 2015-9

      I want the sales number to show only last 12 YearPeriod.

      Then I can only see YearPeriod from 2014-10 to 2015-9.

       

           

      DayYearWeekMonthYrWkYrPer Sales
      1.1.2013201311  2013-12013-1      150.000    
      10.1.2013201321  2013-22013-1      320.000    
      19.1.2013201331  2013-32013-1      272.246    
      28.1.2013201351  2013-52013-1      610.481    
      6.2.2013201362  2013-62013-2      248.498    
      15.2.2013201372  2013-72013-2      120.766