Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
See attached qvw. Is that what you're looking for?
Gysbert that is exactly what I'm looking for!
Thank you very very much for the quick answer!
Hi Gysbert, do you have any ideas how I can design the qvw that it looks like this example?
Is this what you are looking for?
Thank you very much. That is what I'm looking for.