suppress first x values in bar chart

[#1]

Hi

I want to show the last 12 accumulated values in a chart. I do it using the "Expression.Accumulate -> 12 steps back.

Now my line starts with 0 and builds up for the first 12 month, thereafter shows correct values.

I would like to suppress the first 12 points as they are not fully aggregated. I tried to use a negative number on Presentation.Max Visible but this did not the job.

Using a dimension thet leaves out the first 12 month's did also not work, I assume because the aggregation happens in the graph only.

Any hint?

Thanks, Juerg

[pover · Accepted solution]

Accumulated formulas are always going to need the previous values in the graph to accumulate although you should be able to turn the dimension values and line white or transparent so that it is not seen or if you have access to the script you can create a Asof table

http://community.qlik.com/forums/t/36622.aspx

or a Date Island table where you use the date of the date island as the dimension and the expression is a

sum(if(MonthYear_Island <= MonthYear and MonthYear_Island > addmonths(MonthYear,-12),Sales))

I would try the first 2 options first though.

Regards.

[kji]

Setting Max visible to 12 on the properties/presentation and then checking Reverse (same tab a bit below) should work.

[#4]

Hi Johan / Karl

Finally used a combination of your 2 suggestions

a) Karls solution makes me independent of the selected date range

b) Johan's lets me get rid of the build up ramp.

experiemented also with multiplying the ramp up values to get a somehow representative number on the ramp but it did not work as expected with nonexisting values.

The best however would be asof months', reverse and an expression for max visible that will only hide values within the build up range. Will think about that.

Thanks

Juerg