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

    rolling n period (avg) line chart qlik sense

    Joanna Seldon


      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