Limit Diagram to 12 Bars

[ChristofZ]

Dear Qlik Forum,

I have a Running Sum Accumulation diagram that I want to limit to 12 bars; my formula:

= RangeSum(
Above(
Sum(Money),
0,
12
)
)

plotted against a date in Months.

There is an option to limit bars in my Bar Chart, but it limits the plot to the first 12 etc bars; I need the last 12 bars 😋

Help is highly appreciated, thank you!

regards, Christof

[Padma123 · Accepted solution]

Try..

last 12 values

first 12

[ChristofZ]

thank you - that was helpful. (Missed that setting somehow ...)

The only problem: it works well for the accumulation Average (above), but not for the Rolling Sum (below; which I'm supposed to be making):

The Rolling Sum below misses the values prior to Sep 2023, which the Limitation probably cuts. That's why the diagram looks triangular in shape ...
But it still helped me - the only difference between the 2 are probably the absolute values on the axes. I'll try to sell that one as a success 😇

Thank you!

[ChristofZ · Accepted solution]

The display of a Bar-Chart can be limited

• in the data-tab
• in the display-tab

My problem was, I limited the data in the data-tab, which results in case of a rolling sum in a cut-off triangular diagram, when it should look level (see above).

But I didn't want to limit the data, just the number of displayed bars, which can be limited in the Bar-Chart under tab "Display" - "variable X-axis" - "number of axis-values". In this case, the diagram admits all data necessary for the rolling sum, but limits the display to the desired number of bars.