Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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?