Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rb_cvogt
Contributor
Contributor
‎2022-01-04 11:32 AM

12 Months rolling in Bar Chart as Dimension

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.

Labels (3)
Labels
1,041 Views
0 Likes
1 Reply
rb_cvogt
Contributor
Contributor
‎2022-01-04 03:40 PM
Author

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?

929 Views
0 Likes