3 Month Rolling on Combo Chart with Month Dimension

[Sansraison]

Hello everyone !

Relatively new to Qlik Sense...   I'm stuck on a rolling 3 month calculation.

I want to show on a line chart with Month as the dimension, the last 3 Months result as an average result.

I already have a field (MM3) which avg all my calculation for last 3 months , but i don't use it for this chart as an alternative dimension, the result needed is  2 lines on the same graph without switching dimension

Here's the chart, which use a monthly dimension :

Here's the line calculation, only telling a result by month (and not last 3 month) :

I'd like to have a second line which return for each month the average of last 3 month.

Can anyone help?

Thanks a lot ! 🙂

[Sansraison]

Hello everyone !

Relatively new to Qlik Sense...   I'm stuck on a rolling 3 month calculation.

I want to show on a line chart with Month as the dimension, the last 3 Months result as an average result.

I already have a field (MM3) which avg all my calculation for last 3 months , but i don't use it for this chart as an alternative dimension, the result needed is  2 lines on the same graph without switching dimension

Here's the chart, which use a monthly dimension :

Here's the line calculation, only telling a result by month (and not last 3 month) :

I'd like to have a second line which return for each month the average of last 3 month.

Can anyone help?

Thanks a lot ! 🙂

[sunny_talwar · Accepted solution]

I suggest creating The As-Of Table for this

[Sansraison]

Ok, thank you Sunny !

I created the AsofTable, but i still can't get the expression on my chart working.

I need exactly this :

Can somebody help me to adapt this formula with the correct syntax ? :

Many Thanks ! 🙂

[sunny_talwar]

Did you try to add MonthDiff = {"<=6"} to your expression? and did that not give you what you needed?

[Sansraison]

Nevermind, i actually found it, for those interested :

Many Thanks again Sunny, you are precious to the Qlik Community as i saw you on most of the solutions post of Qlik Support Forum ! 🙂