Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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.

Highlighted
martinr_
Contributor

Re: Moving Average

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