topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

Tue, 02 Dec 2014 17:56:09 GMT

I am having trouble with displaying my bar chart at 100%. I was able to accomplish this in esxcell but i can't get it to work in QV.

Dimension:

Product Name

Measure:

% of Total (=SUM({<month_offset={[>=-1<0]}>}price)/100000
%of Last 3 Month (=SUM({<month_offset={[>=-1<0]}>}price)+SUM({<month_offset={[>=-2<0]}>}price)+SUM({<month_offset={[>=-3<0]}>}price)/1000000

Please help!

Re: Stacked Bar Chart

PrashantSangle — Tue, 02 Dec 2014 17:59:27 GMT

Hi,

Click on Relative check box from Expression table.

Regards

Re: Stacked Bar Chart

Tue, 02 Dec 2014 18:11:15 GMT

Thank you!

I am almost there.Here is what my chart looks like now

And i am looking to do something like this:

Re: Stacked Bar Chart

Tue, 16 Dec 2014 20:03:11 GMT

Any suggestions on this one?

Re: Stacked Bar Chart

Wed, 17 Dec 2014 07:28:49 GMT

I think it has to do with dimensions. Now, your expressions are presented per dimension. For each dimension, there is a Last(?) and Total expression. I can imagine that you can achieve the excel layout by using a dimension that contains all your previous dimension units.

Did it help? With a sample qvw I could give you a better answer.

Best,

Re: Stacked Bar Chart

Anonymous — Wed, 17 Dec 2014 09:47:53 GMT

Hi Zhenya,

I think what you need here is a handy thing called ValueList(). This allows you to create a synthetic dimension which you can then use to define two different expressions on the same axis. Here is my example built using ValueList().

More info on ValueList can be seen at: ValueList() – For those tricky situations

As we are creating a synthetic dimension the "Relative" tickbox won't quite work right so you will need to use a bit of set analysis to define the total sales to compare against and give you a nice percentage. The dimensions and expression I used are:

Dimensions: =ValueList('Last 3', 'All'); CategoryName

Expression: =If(ValueList('Last 3','All')='Last 3',Sum({<Month={'Dec'}>}Sales)/Sum(TOTAL {<Month={'Dec'}>} Sales),Sum(Sales)/Sum(TOTAL Sales))

I have attached my example app so you can see what I have done and have a play with it. You will need to tweak it to your own fields but this should be fairly simple.

Hope that helps.

Adam