3 Replies Latest reply: Sep 16, 2012 2:01 PM by Jose Luis Garcia

# Partially stacked chart

Hi

I am unable to solve a business graph. I have three measures (Amount, AmountPendingInvoice and Budget).The sales department has asked me a bar chart with 4 columns: prior to last year, the last year, current year + pending and budget similar to the picture below. This design is it possible with QV11?

I get with three different graphics. The problem is that the values in each chart are not on the same scale

• ###### Re: Partially stacked chart

Hi

Try valuelist function..

hope it helps.

• ###### Re: Partially stacked chart

Hi.

Imagine another dimension for that measure is 151,452 for sales and null() for others.

• ###### Re: Partially stacked chart

Solved.

I created a dimension using Valuelist:

```Measure = ValueList('LY2','LY','Sales','Budget','Forecast')
```

I created sis expressions using pick:

```LY = pick(match(ValueList('LY2','LY','Sales','Budget','Forecast'),'LY2','LY','Sales','Budget','Forecast'),

// Year - 2
Sum({<Year={\$(=Max(Year)-2)}>}  Amount),
// Year - 1
Sum({<Year={\$(=Max(Year)-1)}>}  Amount),
// Sales
Null(),
// Budget
Null(),
// Forecast
Null()
)

Sales=
pick(match(ValueList('LY2','LY','Sales','Budget','Forecast'),'LY2','LY','Sales','Budget','Forecast'),

// Year - 2
Null(),
// Year - 1
Null(),
// Sales
Sum({<Year={\$(=Max(Year))}>}  Amount),
// Budget
Null(),
// Forecast
Null()
)
etc...
```

The resulting chart is this:

Thank you both