topic Re: Combo chart with stacked bars in QlikView

Combo chart with stacked bars

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Combo chart with stacked bars

Gysbert_Wassenaar — Mon, 03 Jul 2017 16:36:19 GMT

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.

Re: Combo chart with stacked bars

Wed, 05 Jul 2017 06:57:57 GMT

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!

Re: Combo chart with stacked bars

anychart — Thu, 26 Jan 2023 20:22:29 GMT

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