2 Replies Latest reply: Sep 21, 2017 4:22 AM by Joanna Seldon RSS

    rolling n period (avg) line chart qlik sense

    Joanna Seldon

      Hi


      I have the following Expression to make a rolling 52/53 week avg (rolling n period)

       

       

      Count(distinct [OrderID] ) as a 1st measure

       

      rangeavg(above(Count(distinct [OrderID] ),0,53)) as a 2nd measure (this is my rolling n period)

       

      WeekEnd(OrderDate) as a dimension

       

      date period from 2013 to the present

       

      I wish the second measure to start from 2014, but I seem to loose the avg values if I place the exclusion {<Year-={'2013'}>} please help

       

      the avg 2013 values are needed to calculate the n period

       

      please help