topic Re: Gap Analysis with a Stacked Bar Chart in QlikView

Gap Analysis with a Stacked Bar Chart

Tue, 15 Jan 2013 13:44:26 GMT

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.

Gysbert_Wassenaar — Tue, 15 Jan 2013 14:00:08 GMT

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

Tue, 15 Jan 2013 14:04:52 GMT

Gysbert that is exactly what I'm looking for!

Thank you very very much for the quick answer!

Perfect!

Wed, 16 Jan 2013 09:16:09 GMT

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

hschultz — Wed, 16 Jan 2013 10:38:24 GMT

Hi there.

Is this what you are looking for?

Wed, 16 Jan 2013 12:18:44 GMT

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