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.