idea Combo Chart: Add stacked bars option by Dimension in Suggest an Idea

Combo Chart: Add stacked bars option by Dimension

pablolabbe — Wed, 25 Nov 2020 08:50:26 GMT

Actually its not possible to create a combo chart with stacked bar charts using a Dimension. It can be only possible using multiple expressions, so it could led to hard coding maintenance if we need to add new categories.

Also we need an option to show values for each bar segment. Not only for the total amount.

In Qlikview we can create such visualization overlapping a line chart over a stacked bar chat using transparency.

Re: Combo Chart: Add stacked bars option

pablolabbe — Wed, 10 Jun 2020 12:57:52 GMT

Re: Combo Chart: Add stacked bars option

millerhm — Wed, 10 Jun 2020 13:05:25 GMT

concur! we've had to regularly go to unsupported extensions for this, which is not ideal, but this is a very common requirement from our end users.

Re: Combo Chart: Add stacked bars option

marinabp — Wed, 10 Jun 2020 13:24:49 GMT

That would be VERY useful! It´s a common requirement for a lot of projects.

Re: Combo Chart: Add stacked bars option

robertonovelloi — Wed, 10 Jun 2020 14:02:10 GMT

Excellent idea Pablo

Re: Combo Chart: Add stacked bars option by Dimension

Henri_Rufin — Wed, 10 Jun 2020 20:35:54 GMT

Indeed it’s been requested many times by some of my developers as well

Re: Combo Chart: Add stacked bars option by Dimension

simonaubert — Fri, 12 Jun 2020 07:28:37 GMT

Hello.

It's a duplicate of this idea :
https://community.qlik.com/t5/Ideas/Combo-Chart-Color-bars-or-lines-with-a-second-dimension/idi-p/1653601

Re: Combo Chart: Add stacked bars option by Dimension

pablolabbe — Mon, 22 Jun 2020 21:26:09 GMT

Hi Simon, I don´t think so because the idea you pointed is related to colors by dimension.

This idea is related to create a stacked bar chart using a dimension like in the bar chart.

Re: Combo Chart: Add stacked bars option by Dimension

RadovanOresky — Fri, 26 Jun 2020 10:08:59 GMT

Very much agree.

I think that the combo chart should be redesigned to support multiple layers, exactly like the native Map object. This would lead to much easier maintenance a awesome variability.

Picasso.js supports this, so I guess that it shouldn't be a problem.

Re: Combo Chart: Add stacked bars option by Dimension

Lech_Miszkiewicz — Sun, 05 Jul 2020 02:00:05 GMT

Very good point @pablolabbe

your request is as much needed as mine regarding horizontal/vertical toggle for combo chart.

lets hope they both get done soon 🤞

Re: Combo Chart: Add stacked bars option by Dimension - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Mon, 03 Aug 2020 13:45:51 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

A rework of the combo chart is hopefully on route during 2020.

Thanks,

Patric

Re: Combo Chart: Add stacked bars option by Dimension

millerhm — Mon, 10 Aug 2020 14:00:12 GMT

@Patric_Nordstrom - thanks for the update, but this seems like a very common use case that is being overlooked. The rework of the Combo chart is necessary, but without stacked bars as an option, we will have to continue to use unsupported extensions for many use cases, which is frustrating for something that seems so basic.

Re: Combo Chart: Add stacked bars option by Dimension

canoebi99 — Tue, 30 Aug 2022 04:30:42 GMT

I see this has been open - collecting feedback for 2 years now?! How many people need to like an idea for it to make it onto the roadmap? .... our clients also need this chart as an option, hard coding expressions to make this work is not ideal.

Re: Combo Chart: Add stacked bars option by Dimension

Patric_Nordstrom — Wed, 31 Aug 2022 08:08:15 GMT

When the new combo chart was released last year a lot was improved:
* Vertical presentation
* Color per measure
* Dimension based reference lines for annotations
* Measure reference lines
* Bar styling with bar width, outline and custom number of bars
* Line styling with point size, line width, dashed solid, curvy and linear
* Custom tooltips
A secondary dimension was on the list but didn't make it to the first release.

From a data literacy perspective stacked bar charts are considered hard to read and confusing to the end users. A stacked combo with a secondary axis is even worse. (https://www.smashingmagazine.com/2017/03/understanding-stacked-bar-charts/)

This idea is fairly popular with 42 likes, ranked 29 among the current open ideas.

That said a secondary dimension is on the roadmap for consideration in the next 6 months.

Re: Combo Chart: Add stacked bars option by Dimension

canoebi99 — Wed, 31 Aug 2022 08:33:09 GMT

Thanks Patrick, this is useful information.

This request is something that we get asked for from clients and whilst "a stacked combo with a secondary axis may be even worse" this is what our clients (end users) ask to see.

If you are able to suggest a better way/chart to display the quantity sold broken down by store then by product category with the sales $ also represented (so we can see stores that sell more but at lower value as well as the breakdown on product category) I would love to pass that suggestion on to the clients and provide them a better option.

Attached is a sample of what we were recently asked to create in QlikSense.

Re: Combo Chart: Add stacked bars option by Dimension

Koen2 — Wed, 08 Feb 2023 14:52:28 GMT

Good to see that there are more people that find this a necessary visual to have in Qlik Sense.

I often use this kind of graphs to show forecasts in the future (supply & demand) en demand broken down in different product or client categories. For me it is not necessary to have a secondary axis, but I would really like to have the possibility to show 1. a line (supply) and 2. a stacked bar graph (demand) in the same graph.

I hope that it will be included in future releases!

Re: Combo Chart: Add stacked bars option by Dimension

UncleRiotous — Fri, 14 Apr 2023 13:56:53 GMT

Once again a pretty basic requirement is missing from Qlik Sense. I don't often use stacked bars but there are times when I really need to. I've just told a senior manager with absolute confidence that I can meet her requirement (the same manager who wanted a pivot table with variable width columns last year) and now I'm going to have to tell them Qlik can't do it.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:13:14 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Combo Chart: Add stacked bars option by Dimension - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:13:16 GMT