Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

bzggriffin
New Contributor

Target distribution line on bar chart

I have a bar chart that I use to show the distribution of monthly sales between new business and existing business. I would like to be able to project a line on top of the chart that shows where we would like the distribution to be. For instance, if June's sales were $400 to new business and $600 to existing business and we want salespeople to target a 50/50 distribution, the line chart would pass through the month at the $500 point.

Here's an Excel rendition of what I'd like the chart to look like:

TargetLine.png

Can a create a similar target distribution line in QlikView? I've attached a QVW containing the same sample data.

Thanks. -- Ben

Tags (2)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Target distribution line on bar chart

Ben, see attached

3 Replies
mov
Esteemed Contributor III

Re: Target distribution line on bar chart

Ben, see attached

Re: Target distribution line on bar chart

See attached qvw


talk is cheap, supply exceeds demand
bzggriffin
New Contributor

Re: Target distribution line on bar chart

Perfect. Michael / Gysbert, thank you for getting back to me so quickly. -- Ben

Community Browser