Combo chart with stacked bars

[#1]

Hi there,

I am fairly new to Qlikview so my apologies if this has been answered before. I want to see a line chart and stacked bar chart in the same visual, so I am trying to create a Combo Chart where on the X-axis I have months per year and on the Y-axis I have percentages.

The trendline (line chart part) is calculated by =(sum(dimension1) / sum(dimension2))*100 . This works fine on its own.

Dimension1 has several textual fiels/values which i want to display as a stacked bar chart (per month) to visualize the share of each value.

In this video: Stacked Chart with Line Chart - YouTube you can see how to do that by hard coding each value of dimension1 in an expression. However, dimension1 in my example is a field that can be modified freely by each individual customer. Customer A can have 4 values, customer B can have 6, and they can all be entirely different.

Is there a way that you can create a stacked bar chart, in the combo chart visual, without having to hard code each value of dimension1?

Thanks in advance!

PS: Sorry, no example file since i work with non-anonymous customer data.

[Gysbert_Wassenaar · Accepted solution]

Nope. You want a combi chart that at the same time uses one single dimension and also uses two dimensions. That's not possible. What you can try instead is creating two charts and resize and position them so they overlay perfectly when you put one on top of the other. You can turn the background of the top chart transparent so you 'see' only one chart. It's a bit tricky, but it can be done.

[#3]

Good to know that I don't have to waste time on trying to make that work then

I am going for your suggestion, thanks!

[andreykh]

Check out the combo chart extension:
https://qlik.anychart.com/news/combo-chart-circular-gauge/