Announcements
cancel
Showing results for
Did you mean:
Partner - Contributor II

## 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

1 Solution

Accepted Solutions
Partner - Contributor II
Author

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 - 2Sum({<Year={\$(=Max(Year)-2)}>}  Amount), // Year - 1Sum({<Year={\$(=Max(Year)-1)}>}  Amount), // SalesNull(), // BudgetNull(), // ForecastNull())Sales=pick(match(ValueList('LY2','LY','Sales','Budget','Forecast'),'LY2','LY','Sales','Budget','Forecast'),  // Year - 2Null(), // Year - 1Null(), // SalesSum({<Year={\$(=Max(Year))}>}  Amount), // BudgetNull(), // ForecastNull())etc...`

The resulting chart is this:

Thank you both

3 Replies
MVP

Hi

Try valuelist function..

hope it helps.

Thanks & Regards, Mayil Vahanan R
Master II

Hi.

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

Partner - Contributor II
Author

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 - 2Sum({<Year={\$(=Max(Year)-2)}>}  Amount), // Year - 1Sum({<Year={\$(=Max(Year)-1)}>}  Amount), // SalesNull(), // BudgetNull(), // ForecastNull())Sales=pick(match(ValueList('LY2','LY','Sales','Budget','Forecast'),'LY2','LY','Sales','Budget','Forecast'),  // Year - 2Null(), // Year - 1Null(), // SalesSum({<Year={\$(=Max(Year))}>}  Amount), // BudgetNull(), // ForecastNull())etc...`

The resulting chart is this:

Thank you both

Community Browser