Bar chart limit

[stephenedberkg]

i have 24 months in barchart.

but want to show last 12 months only

how to limit the dimension?

PFA

[Digvijay_Singh]

You can use set analysis in expression something like Sum({<Month = {">=$(=Max(Month)-12)"}>}Value)

[amit_saini]

Hi,

PFA

Thanks,

AS

[t_chetirbok]

Hello!

try this set analysis: sum({<DATE={">=$(=addmonths(max({1}DATE),-11))"}>} VALUE)

[stephenedberkg]

Dear Digvijay

if i selected the Week 15 mean i have the 24 weeks

but 1 st 12 weeks are history weeks last 12 weeks are forecast weeks

i want to show the last 12 weeks only

my expression is

=num(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP={$(=Max(Week_UP))}>}Sales),0.00)

[Anonymous]

I think you should check this, every thing is mentioned here?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

[stephenedberkg]

Dear amit.saini

i am using personal edition only so i cant open your QVW files

[ecolomer]

Select limit of values:

[Anonymous]

Go to dimension limit select option and the give the value there than it show only that values .

[stephenedberkg]

i want to show last 12 weeks only