topic Solution for Stacked bar chart with target references for each individual bar in QlikView

Solution for Stacked bar chart with target references for each individual bar

Thu, 31 Mar 2016 13:07:14 GMT

Hello, I am trying to determine the best solution for a use case. I am trying to create a stacked bar chart that has a pass/fail for each bar and two reference lines / high and low target lines for each individual bar. Currently you can only define one reference line not two. I have attached a mock-up of what I am trying to achieve. Can someone give me some ideas of how best to achieve this visualization? T

Thanks!

Re: Solution for Stacked bar chart with target references for each individual bar

marcus_sommer — Thu, 31 Mar 2016 13:53:29 GMT

If your chart is quite static you could try to use a background-image for your low/high targets. If not you will be need two/several charts which are laying over eachother to get the stacked bar and the targets as a symbol. The description of pass/fail could you get with a dual(string, numeric vale) and for your arrow-axis you will need an arrow-object.

- Marcus

Re: Solution for Stacked bar chart with target references for each individual bar

atair — Sat, 09 Jan 2021 11:09:54 GMT

I am trying to achieve something similar using box plot.

Does anyone have other ideas?

Re: Solution for Stacked bar chart with target references for each individual bar

QFabian — Sat, 09 Jan 2021 15:15:02 GMT

Hi @atair , this is the closest thing that i can do, its going to depend on your tables structure, so as an example, i created a simple data table. Please check the .qvw file attached.

Re: Solution for Stacked bar chart with target references for each individual bar

atair — Mon, 11 Jan 2021 07:43:51 GMT

Thanks @QFabian . That covers all the expected measurements.

I wish @Anonymous would allow customized Symbols or Lines for this.