12 Month rolling: every month has to contain the sum of units sold in the twelve months before.

[Anonymous]

Good Morning Everybody,

I'm Lorenzo, italian and quite new to Qlik Sense. I have just begun to work with this amazing tool in order to obtain some really interesting market analysis. In order to carry out the last chart I want to create I need the famous 12 months rolling sum. This means I want a combo chart in which each months contains the sum of the units sold in the last 12 months.

In my database I have this fields: Month,  Year,  Date(DD/MM/YYYY),  Brand, Number of units sold.

I think it is quite simple but I'm totally lost.

Thanks in advance.

Lorenzo 

[kkkumar82]

Try this

Calculating rolling n-period totals, averages or other aggregations

The expressions work even in Qlik Sense