Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

i_want_to_learn
New Contributor

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

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 

Tags (1)
1 Reply
kkkumar82
Valued Contributor III

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

Try this

Calculating rolling n-period totals, averages or other aggregations

The expressions work even in Qlik Sense