Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Calculating rolling n-period totals, averages or other aggregations
The expressions work even in Qlik Sense