1 Reply Latest reply: May 9, 2017 4:34 AM by AC BC RSS

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

    Lorenzo Caravati

      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