Moving Average

[User12321]

Hi,

I want to create a straight table with a moving average column.

I am facing difficulty aggregating by month and getting it to work. 

Any suggestion please. Thank you .

[Andrea_Spinetti]

Hi @User12321 , if I got your request right, I would suggest you create a Master Calendar.

Creating a Master Calendar will definitely help the dates aggregation as you will have a complete list of all the dates in the calendar range, avoiding multiplication of the same data in the fact table and making it possible to use the same Calendar for many fact dates.

Have a look here: Creating A Master Calendar

The video shows the process of creating a Master Calendar in QlikView but the structure will be the same in QlikSense.

[User12321]

Hi @Andrea_Spinetti ,

Thanks for helping. 

[Andrea_Spinetti]

Hello @User12321, are you able to share a sample App with dummy data so I can test directly with it?