Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?