topic Re: Add Target point on the bar chart in QlikView

Add Target point on the bar chart

Mon, 20 Apr 2015 03:34:55 GMT

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.

Re: Add Target point on the bar chart

Gysbert_Wassenaar — Mon, 20 Apr 2015 07:46:02 GMT

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

Re: Add Target point on the bar chart

Mon, 20 Apr 2015 09:15:16 GMT

Hi Gysbert,

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

Re: Add Target point on the bar chart

Mon, 20 Apr 2015 12:44:14 GMT

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'.

Re: Add Target point on the bar chart

Tue, 21 Apr 2015 04:37:22 GMT

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.

Re: Add Target point on the bar chart

Fri, 24 Apr 2015 07:35:23 GMT

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

Re: Add Target point on the bar chart

Fri, 24 Apr 2015 08:49:24 GMT

try using this as a starting point