Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling month within chart

Hello together,

I am trying to create a rolling months chart showing the biggest as well as the smalles value.

Rolling months means that we have a date and value range from May 2011 to April 2013.

Period YearValue12 mr valueExample
May-1183.1

Jun-1152.1

Jul-1151.6

Aug-1161.7

Sep-1154.6

Oct-1166.1

Nov-1145.6

Dec-119

Jan-1273.1

Feb-1236.7

Mar-1276

Apr-1277.1

May-1248.2651.8=SUM(May 11 - Apr 12)
Jun-1276.5676.2=SUM(Jun 11 - Jul 12)
Jul-1270.6695.2=SUM(Jul 11 - Aug 13)
Aug-1213.3646.8"
Sep-1272.1664.3"
Oct-1214.3612.5"
Nov-1259.3626.2"
Dec-1264.8682"
Jan-1337.2646.1"
Feb-136.5615.9"
Mar-1394.8634.7"
Apr-134.7562.3=SUM(May 12 - Apr 13)

My problem is now, how to set up a chart showing the the values in column 3 from May 2012 to April 2013.

I have set up this expression:

=SUM({<

          [Measures (Key)]={'Operating Profit (EBIT)'},

          [Version single (Key)]={'Actual'},

          Period

>}Values)/1000000

including the function "Accumulation for 12 steps back".

To this point all existing Period Year entries are shown within the chart.

To get rid of this I have set a start and end value within the axes tab (Scale).

This seems to be fine as long as I use only line charts and no bar charts.

Furthermore I would like to identify the highest and smallest value.

Normally I would use the rank function to identify it but it could be possible, that rank=1 is located in the results I have supressed by setting a min/max scalling within the axes tab of the chart properties.

And now I have no ideas left how to set up this chart in a useful way.

Any suggestions?

0 Replies