Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Gap Analysis with a Stacked Bar Chart

Dear Community,

I have a problem in creating a Stacked Bar Chart.

The basics are clear to me, that means I know how to create a Stacked Bar Chart.

Unfortunately I'm not able to meet my requirement in total.

Short description of my Problem:

I have to build up a Chart that compares a actual value with a planned value.

For example, I need to visit 6 Clients per day and my actual is 4.

Now I want to show a chart that shows the actual part of the bar in green.

The part of the missing 2 visits must be displayed in Yellow.

So everybody can see the gap.

Furthermore there is another scenario that could happen.

A person might be able to visit 8/6 clients a day.

Now the chart should look as the following. The planned area (6) need to be displayed in green.

The part of the more visits need to be displayed in red.

I hope you understand my problem.

I'am looking forward to your comments.

1 Solution

Accepted Solutions

Re: Gap Analysis with a Stacked Bar Chart

See attached qvw. Is that what you're looking for?


talk is cheap, supply exceeds demand
5 Replies

Re: Gap Analysis with a Stacked Bar Chart

See attached qvw. Is that what you're looking for?


talk is cheap, supply exceeds demand
Not applicable

Re: Gap Analysis with a Stacked Bar Chart

Gysbert that is exactly what I'm looking for!

Thank you very very much for the quick answer!

Perfect!

Not applicable

Re: Gap Analysis with a Stacked Bar Chart

Hi Gysbert, do you have any ideas how I can design the qvw that it looks like this example?

Calls.jpg

hschultz
Contributor

Re: Gap Analysis with a Stacked Bar Chart

Hi there.

Is this what you are looking for?

Not applicable

Re: Gap Analysis with a Stacked Bar Chart

Thank you very much. That is what I'm looking for.

Community Browser