Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to change the x-axis start month?

Hi,

I'm doing a chart with the accumulation 12 functionality.

My problem with the chart, I would like to show only the results after the initial 12 month accumulation.

In Qlikview I didnt find a way to make the chart start after the 12 months without selecting the data.

Please see below my chart in qlikview

2-05-2014 9-34-45 AM.png

and the idea is to have the following functionaly (I have did this in excel as example)

2-05-2014 9-35-44 AM.png

Please find enclosed the example data report

I appreciate your support!

Thanks in advance, Leandro

1 Solution

Accepted Solutions

Re: How to change the x-axis start month?

Create a Line Chart

Dimension

Add Calculated Dimension

=IF(Month > 12, Month)

Tick Suppress When Value is Null

Expression (REF: Henric)

Aggr(RangeSum(Above(SUM(Data),0,12)),Month)

Hope this helps...

2 Replies
Employee
Employee

Re: How to change the x-axis start month?

This is not possible using this type of accumulation. The accumulation is made on the possible data; and the graph shows the possible months: Then that is what the curve looks like.

What you can do instead is the following:

  • As expression, use: Sum(Aggr(RangeSum(Above(Sum ({$<Month=>} Data),0,12)),Month))
  • Turn off the accumulation

Then you can select the months you want to see, and the expression will calculate a 12-month accumulation also outside the scope of the selection.

See more on:Calculating rolling n-period totals, averages or other aggregations

HIC

Re: How to change the x-axis start month?

Create a Line Chart

Dimension

Add Calculated Dimension

=IF(Month > 12, Month)

Tick Suppress When Value is Null

Expression (REF: Henric)

Aggr(RangeSum(Above(SUM(Data),0,12)),Month)

Hope this helps...

Community Browser