Add Target point on the bar chart

[#1]

Hi,

I would like to create a bar chart which display region sales amount by Month Year. I also want to add sales target points on the bar chart like below:

How can I add those target points?

Thanks.

[Gysbert_Wassenaar]

You can do that by using Error Bars as explained in this blog post: Bar chart target lines in QlikView (The Qlik Fix!)

[#3]

Hi Gysbert,

Thank you for your suggestion. Can I show value on data point of Error Bars?

[#4]

you can add one more expression which will be calculating the target sum

and then on expression tab uncheck 'bar' checkbox and check 'values on data points'.

[#5]

Hi Alexandra,

Thank you for your reply. I tried your method, but the data point are shown on top of the bars.

The data point I would like to show are on the top of error bars.

[#6]

try this:

create second expression which is

dual(

     sum(point1),

     sum(point1) - sum(sales)

)

, give it argb(0,255,255,255) - transparent color

have a stacked bar chart and add show value on data points for this expression

[#7]

try using this as a starting point