Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

rolling n period (avg) line chart qlik sense

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

1 Solution

Accepted Solutions

Re: rolling n period (avg) line chart qlik sense

Try this

RangeAvg(Above(Count(DISTINCT {<Year>} [OrderID]), 0, 53)) * Avg({<Year-={'2013'}>} 1)

2 Replies

Re: rolling n period (avg) line chart qlik sense

Try this

RangeAvg(Above(Count(DISTINCT {<Year>} [OrderID]), 0, 53)) * Avg({<Year-={'2013'}>} 1)

joeybird
Contributor II

Re: rolling n period (avg) line chart qlik sense

Hi

Sunny your amazing as always

works brill

thank you

Community Browser