topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

Thu, 25 Feb 2016 19:14:13 GMT

All,

Not sure if this is possible, but I am looking to create a stacked bar chart with two expressions: Spend and Budget. What I was to try to accomplish is to have the Budget bar one static color and value, but I want to break up the spend into a true stack bar chart by which phase it is in. So basically a side by side bar chart with one static and one stacked by phase. I've looked into "Bar off-set" but I can't figure it out. Let me know if possible!

Re: Stacked Bar Chart

Clever_Anjos — Thu, 25 Feb 2016 19:33:35 GMT

Would you mind prototyping what you have in mind? Excel or Paint picture would be nice

Re: Stacked Bar Chart

johnw — Thu, 25 Feb 2016 20:50:09 GMT

Well, it only has one expression, and I did the actual work in the data model / script, but is this how you want it to look? If so, might this do the trick? If not, can you tell us a bit about your actual data model?

Re: Stacked Bar Chart

Thu, 25 Feb 2016 20:59:46 GMT

This is exactly what I would be looking for but it would have to be two expressions: Sum(Spend) & Sum(Budget)

The spend would be broken out by invoice phase over the dimension YEAR and Invoice Phase but the invoice phase would be stacked in the spend expression if that makes sense, sorry complicated request

Re: Stacked Bar Chart

johnw — Thu, 25 Feb 2016 21:20:12 GMT

OK, I assume the real issue is that Budget and Spend are both on the same row of a table, not that you specifically need exactly those two expressions. Here's an example with Budget and Spend on the same row, and a fake dimension of [Type] that controls the chart behavior. There might be a better way. This seems clunky to me.

Re: Stacked Bar Chart

Thu, 25 Feb 2016 23:18:49 GMT

Thanks John, I'm not sure this is doable given our client's data but great for demo purposes.