topic Partially stacked chart in QlikView

Partially stacked chart

joseluis_garcia — Sun, 09 Sep 2012 19:24:00 GMT

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

MayilVahanan — Sun, 09 Sep 2012 20:39:37 GMT

Try valuelist function..

hope it helps.

Re: Partially stacked chart

whiteline — Mon, 10 Sep 2012 04:36:36 GMT

Hi.

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

Re: Partially stacked chart

joseluis_garcia — Sun, 16 Sep 2012 18:01:25 GMT

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