Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
gian_ve77
Contributor
Contributor

Moving Average using a variable interval

I have a problem that i really don't know how to solve. Basically what i need to achieve is to build a table that contains a moving average for a list of items based on a rolling date. I need to build it in the script cause i need it later to make other calculations. The difficult part is that the interval should be different for every single item. i created an example in excel, where i calculated a 3 days moving average for item A and a 5 days moving average for item B.

ITEMMOVING AVG INTERVAL
A3
B5
2 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Maybe look at the Above() function.

gian_ve77
Contributor
Contributor
Author

It would work if i did it in a chart or a table, but i need to obtain the same result in my script. Any suggestion?