Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
martinr_
Contributor

Moving Average

Hi,

I have a line diagram with the dimension year - month.
Formula is ….
Dual(Num(YEAR([DATE]),00)&' - '&MONTHNAME,Num(YEAR([DATE]),00)&NUM(Month([DATE]),00))

If I now show the sum over several years, that fits "normal" buzz correctly.
Formula is ....
Sum(Price)

 

qlik_sum.JPG

 

 




When calculating the moving average, the display shows no result. Is empty.
Formula is .... Aggr(RangeAVG(Above(Sum({<BELEGTYP={'RE'}>}GESPREISNETTO),0,RowNo())),Num(YEAR([DATE]),00)&' - '&MONTHNAME)

Where is my mistake here? I can not find anything there.

3 Replies
danilostochi
Contributor

Re: Moving Average

Hi, could you post .qvf?

(44) 9 9993-3605 TIM, WhatsApp, danilo16stochi@hotmail.com
martinr_
Contributor

Re: Moving Average

Hi, here is the qvf file.

martinr_
Contributor

Re: Moving Average

Can someone help me, I have not found a solution yet.