Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator II
Creator II

Hi, could you post .qvf?

+55(44) 9 9993-3605, WhatsApp
E-Mail or Skype - danilo16stochi@hotmail.com
Highlighted
Creator
Creator

Hi, here is the qvf file.

Highlighted
Creator
Creator

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