3 Replies Latest reply: Jul 11, 2013 11:43 AM by Ben Gottesman RSS

    Target distribution line on bar chart

    Ben Gottesman

      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