12 Months rolling in Bar Chart as Dimension

[rb_cvogt]

Hi Qlik-Community,

I'm working on an overall KPI Dashboard. The KPIs are presented monthly and always have an is to plan deviation. Down under the KPI I want to show different charts in a Multibox. As main filters I got year and month, so everyone can look at the monthly KPI's of each year and month but in the charts I want to show the course of a specific KPI as 12 months rolling.

How can I make the dimension (month) of the bar chart independent of the main filter (year and month) and showing them as I wish?

I have already tried various possible solutions from this forum, but have not yet come to a suitable result.

Can somebody help me, please? I'm new to Qlik and Developing. Thank you in advance.

[rb_cvogt]

With the formula

Count({<Year=, Quarter=, Month=, DateKey={">=$(=Num(MonthStart(AddMonths(Max(DateKey),-12)))) <=$(=Num(AddMonths(Max(DateKey),0)))"}>} [Unique Month])

I get the correct result displayed as a table.
How can I use this formula to display my bar charts 12 months rolling?