topic Rolling average line chart in QlikView

Rolling average line chart

snehamahaveer — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Stuck with a new situation!! Please help.

I am trying to create a line chart which will have rolling average of targets. eg Month 1 = Targets%/1, Month 2 = Targets% (2 months total)/2, and so on.

Can some one tell me how and what will be the best way to do it.

My sample data is attached.

Dimensions are Month and Division, and expression is the rolling average.

Many thanks for your help!!

Re: Rolling average line chart

Wed, 03 Aug 2016 15:00:11 GMT

maybe...

Re: Rolling average line chart

Wed, 03 Aug 2016 15:09:53 GMT

dimension: Month and Division

expression1: sum(%target)/sum(Division)

expression2: sum(%target)

Re: Rolling average line chart

snehamahaveer — Thu, 04 Aug 2016 15:29:20 GMT

Hi Rodrigo,

Thanks for your reply.

But this is what I want to achieve.

I want a line chart where the value for Aug will be sum( months apr to aug)/num of months

Re: Rolling average line chart

Thu, 04 Aug 2016 17:09:49 GMT

sum( %target)/count(Month)

Re: Rolling average line chart

Frank_Hartmann — Thu, 04 Aug 2016 17:47:26 GMT

Dimension:

month

Expressions:

Rangesum(above(aggr(sum({<Division={'1'}>}%target),Month,Division),0,RowNo()))/RowNo()

Rangesum(above(aggr(sum({<Division={'2'}>}%target),Month,Division),0,RowNo()))/RowNo()

Edit: Sortorder for month --->check LoadOrder-->original

hope this helps